PROJECTFORECASTQUANTITY
Overview
The PROJECTFORECASTQUANTITY function calculates the original forecasted quantity of one or more project(s) and task(s).
Syntax
=PROJECTFORECASTQUANTITY(
Connection,
Project,
Revision,
Task,
AccountGroup,
CostCode,
InventoryItem,
FromPeriod,
ToPeriod
)
Arguments
The PROJECTFORECASTQUANTITY function uses the following arguments (see our article on Filtering Velixo functions):
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Required | The Project(s) to include |
| Required | The Project Revision to include |
| Optional | The Task(s) to include |
| Optional | The Account Group(s) to include |
| Optional | The Cost Code(s) to include |
| Optional | The Inventory Item(s) to include |
| Required | Starting Financial period in MM-YYYY format |
| Required | Ending Financial period in MM-YYYY format |
Example
=PROJECTFORECASTQUANTITY(
"Demo",
"BUDGETBYM",
"2",
"01",
"MATERIAL",
,
"AACOMPUT01",
"03-2019",
"03-2019"
)
Description
Calculates the forecasted quantity for revision 2 of the forecast of BUDGETBYM, during the third financial period of 2019 and filtered on task 01, account group MATERIAL and inventory item AACOMPUT01
Result
1.00