PROJECTCOMMITTEDQUANTITY
Overview
The PROJECTCOMMITTEDQUANTITY function calculates the original committed quantity of one or more projects and tasks.
Syntax
=PROJECTCOMMITTEDQUANTITY(
Connection,
Project,
Task,
AccountGroup,
CostCode,
InventoryItem
)
Arguments
The PROJECTCOMMITTEDQUANTITY 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
=PROJECTCOMMITTEDQUANTITY(
"Demo",
"20231001",
"03",
"SUB",
"03460",
"<N/A>"
)
Description
Calculates the original committed quantity for task 03, for the account group SUB, and cost code 03460 in the 20231001 project.
Result
1