SI.PROJECTESTIMATEQUANTITY

Overview

The SI.PROJECTESTIMATEQUANTITY returns the quantity set for one or more estimates configured for a specified project/projects, optionally filtered by Task ID, CostType ID, and/or Item ID.

Syntax

CODE

=SI.PROJECTESTIMATEQUANTITY(Connection, Project, EstimateId, TaskId, CostTypeId, ItemId, WorkflowType, IncludeChildDimensionBalances)

Arguments

The SI.PROJECTESTIMATEQUANTITY function uses the following arguments (please see the article on Filtering Techniques for Velixo Functions for how to include multiple values in an argument):

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection as configured in the Connection Manager
`Project`	Required	The ID of one or more projects containing the estimate wanted
`EstimateId`	Optional	The ID of one or more estimates for which the quantity value is wanted. (If left empty value, the Primary estimate is used.)
`TaskId`	Optional	The ID of one or more tasks to be used to filter the results (If left empty value, estimates for all tasks will be included)
`CostTypeId`	Optional	The ID of one or more Cost Types to be used to filter the results (If left empty value, estimates for all Cost Types will be included)
`ItemId`	Optional	The ID of one or more Items to be used to filter the results (If left empty value, estimates for all Items will be included)
`WorkflowType`	Optional	The workflow types to be included in the results. Allowed values: `O` (for Original) `R` (for Revision) `F` (for Forecast) `A` (for Approved change) `P` (for Pending change) `T` (for Other) Values can be combined. For example if `"APT"` is used, then values for Approved change, Pending change and Other Workflow types will be returned.
`IncludeChildDimensionBalances`	Optional	`TRUE` or `FALSE` (Default) Determines if (for dimensions that have child dimensions) the balances of child dimensions are included in the calculation of the total balance. This argument only affects balances if: The `Location` argument is defined and/or Other dimensions are specified in the `Dimensions` or `UserDefinedDimensions` arguments. This argument performs similarly to the `Includesubdimensions` checkbox in Sage Intacct's stock reports such as Account Balances:

Examples

Example 1 - filtered by project (job) and a single task

CODE

=SI.PROJECTESTIMATEQUANTITY("Sage", "20-005",,"G01-040")

Description
Returns quantity for primary estimate for task number G01-040 in project 20-005

Result

(cell references have been used for some arguments in this example)

Example 2 - filtered by estimate, project, and multiple tasks

CODE

=SI.PROJECTESTIMATEQUANTITY("Sage", "20-005","100",C5#)

Description
Returns the quantity for estimate 100 for all tasks displayed by the function in cell C5 for project 20-005

Result

[data-colorid=j3l9k2f7x8]{color:#183247} html[data-color-mode=dark] [data-colorid=j3l9k2f7x8]{color:#b8d2e7}[data-colorid=pdhswi2qu5]{color:#183247} html[data-color-mode=dark] [data-colorid=pdhswi2qu5]{color:#b8d2e7}Overview

Syntax

Arguments

Examples

Example 1 - filtered by project (job) and a single task

Example 2 - filtered by estimate, project, and multiple tasks

Overview