PROJECTCHANGEORDERQUANTITY
Overview
The PROJECTCHANGEORDERQUANTITY function calculates the change order quantity of one or more projects and tasks.
Syntax
=PROJECTCHANGEORDERQUANTITY(
Connection,
Project,
Task,
AccountGroup,
CostCode,
InventoryItem
)
Arguments
The PROJECTCHANGEORDERQUANTITY 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
=PROJECTCHANGEORDERQUANTITY(
"Demo",
"2017CU01",
"02",
"SUB",
"02450",
"<N/A>"
)
Description
Calculates the change order quantity of task 02 in the 2017CU01 project (filtered by AccountGroup=SUB
, CostCode=02450
, and InventoryItem=<N/A>
)
Result
1