The PROJECTCOMMITTEDQUANTITY function calculates the original committed quantity of one or more projects and tasks.
=PROJECTCOMMITTEDQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem)
The PROJECTCOMMITTEDQUANTITY function uses the following parameters (see our article on including multiple parameter values):
The name of the connection as configured in the Connection Manager
The Project(s) to include
The Task(s) to include
The Account Group(s) to include
The Cost Code(s) to include
The Inventory Item(s) to include
=PROJECTCOMMITTEDQUANTITY("Demo","20171001", "03", "SUB", "03460", "<N/A>")
Calculates the original committed quantity for task 03 in the 20171001 project.