PROJECTFORECASTAMOUNT
Overview
The PROJECTFORECASTAMOUNT function calculates the original forecasted amount of one or more project(s) and task(s).
Syntax
=PROJECTFORECASTAMOUNT(
Connection,
Project,
Revision,
Task,
AccountGroup,
CostCode,
InventoryItem,
FromPeriod,
ToPeriod
)
Arguments
The PROJECTFORECASTAMOUNT 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 Forecast Revision(s) 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 or a date in a valid Excel format* |
| Required | Ending Financial period in MM-YYYY format |
Example
=PROJECTFORECASTAMOUNT(
"Demo",
"BUDGETBYM",
"2",
"01",
"MATERIAL",
,
"AACOMPUT01",
"03-2019",
"03-2019"
)
Description
Calculates the forecasted amount for revision 2 of the forecast of the BUDGETBYM project (filtered on task 01, account group MATERIAL, and inventory item AACOMPUT01)
Result
400.00