The PROJECTBUDGETAMOUNT function calculates the original budgeted amount of one or more project(s) and task(s).
PROJECTBUDGETAMOUNT(Connection, Project, Task, AccountGroup, CostCode,InventoryItem, UseProjectCurrency)
The PROJECTBUDGETAMOUNT function uses the following parameters (see our article on Filtering Velixo functions):
The name of the connection as configured in the Connection Manager
The Project(s) to include
The Task(s) to include
The Account Group(s) to include
The Cost Code(s) to include
The Inventory Item(s) to include
TRUE/FALSE value indicating if the amount should be returned in the project's currency (default = FALSE)
=PROJECTBUDGETAMOUNT("Demo", "Planning" , "", , , "", FALSE)
Calculates the original budgeted amount of all tasks for the Planning projects and return the value in the default currency.