PROJECTCHANGEORDERQUANTITY

Overview

The PROJECTCHANGEORDERQUANTITY function calculates the change order quantity of one or more projects and tasks.

CODE

=PROJECTCHANGEORDERQUANTITY(Connection, Project, Task, AccountGroup, CostCode,  InventoryItem)

The PROJECTCHANGEORDERQUANTITY function uses the following arguments (see our article on Filtering Velixo functions):

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection as configured in the Connection Manager
`Project`	Required	The Project(s) to include
`Task`	Optional	The Task(s) to include
`AccountGroup`	Optional	The Account Group(s) to include
`CostCode`	Optional	The Cost Code(s) to include
`InventoryItem`	Optional	The Inventory Item(s) to include

CODE

=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