PROJECTCHANGEORDERAMOUNT
Overview
The PROJECTCHANGEORDERAMOUNT function calculates the change order amount of one or more project(s) and task(s).
Syntax
=PROJECTCHANGEORDERAMOUNT(
Connection,
Project,
Task,
AccountGroup,
CostCode,
InventoryItem,
UseProjectCurrency
)
Arguments
The PROJECTCHANGEORDERAMOUNT 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 |
| Optional |
|
Example
=PROJECTCHANGEORDERAMOUNT(
"Demo",
"2017CU01",
"02",
"SUB",
"02450",
"<N/A>",
TRUE
)
Description
Calculates the change order amount of the 02 task in the 2017CU01 project (filtered by: AccountGroup=SUB
, CostCode=02450
, and InventoryItem=<N/A>
) and returns the value in the project's defined currency
Result
2000