PROJECTCOMMITTEDQUANTITY

Overview

The PROJECTCOMMITTEDQUANTITY function calculates the original committed quantity of one or more projects and tasks.

CODE

=PROJECTCOMMITTEDQUANTITY(
    ConnectionName,
    Project,
    Task,
    AccountGroup,
    CostCode,
    InventoryItem
)

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

Argument	Required/Optional	Description
`ConnectionName`	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

=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