PROJECTREVISEDCOMMITTEDQUANTITY

Overview

The PROJECTREVISEDCOMMITTEDQUANTITY function calculates the revised committed quantity of one or more projects and tasks.

Syntax

CODE

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

Arguments

The PROJECTREVISEDCOMMITTEDQUANTITY 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

Example

CODE

=PROJECTREVISEDCOMMITTEDQUANTITY("Demo","20171001", "03", "SUB", "03460", "<N/A>")

Description

Calculates the revised committed quantity of task 03 in the 20171001 project (filtered by AccountGroup=SUB, CostCode=03460, and InventoryItem=N/A)

Result

1