PROJECTBUDGETQUANTITY
Overview
The PROJECTBUDGETQUANTITY function calculates the original budgeted quantity of one or more projects and tasks.
Syntax
=PROJECTBUDGETQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem)
Arguments
The PROJECTBUDGETQUANTITY 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 |
| 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 |
Example
=PROJECTBUDGETQUANTITY("Demo","Planning","",,,"" )
Description
Calculates the original budgeted quantity of the Planning project and its associated tasks.
Result
95