PROJECTCOSTATCOMPLETION
Overview
The PROJECTCOSTATCOMPLETION function calculates the cost at completion of one or more projects and tasks.
Syntax
=PROJECTCOSTATCOMPLETION(
Connection,
Project,
Task,
AccountGroup,
CostCode,
InventoryItem,
UseProjectCurrency
)
Arguments
The PROJECTCOSTATCOMPLETION 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
=PROJECTCOSTATCOMPLETION(
"Demo",
"FLDEVELOP1",
"L01",
"SUB",
"09200",
"<N/A>",
TRUE
)
Description
Calculates the cost at completion of task L01 in project FLDEVELOP1 (filtered by the specified AccountGroup
, CostCode
, and InventoryItem
) and returns the value in the Project's defined currency.
Result
0