PROJECTCOMMITTEDINVOICEDAMOUNT
Overview
The PROJECTCOMMITTEDINVOICEDAMOUNT function calculates the committed invoiced amount of one or more projects and tasks.
Syntax
=PROJECTCOMMITTEDINVOICEDAMOUNT(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, UseProjectCurrency)
Arguments
The PROJECTCOMMITTEDINVOICEDAMOUNT 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
=PROJECTCOMMITTEDINVOICEDAMOUNT("Demo","20171001", "03", "SUB", "03460", "<N/A>", FALSE)
Description
Calculates the committed invoiced amount of task 03 in the 20171001 project (filter by the specified AccountGroup
, CostCode
, and InventoryItem
) and returns the value in the default currency
Result
1485