PROJECTCOSTTOCOMPLETE
Overview
The PROJECTCOSTTOCOMPLETE function calculates the Cost to Complete for one or more projects and tasks.

Syntax
=PROJECTCOSTTOCOMPLETE(
Connection,
Project,
Task,
AccountGroup,
CostCode,
InventoryItem,
UseProjectCurrency
)
Arguments
The PROJECTCOSTTOCOMPLETE 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
Assuming the following project information within the ERP:

=PROJECTCOSTTOCOMPLETE(
"ACE",
"1002HOTEL",
"01",
"LABOR",
"01313",
,
FALSE
)
Description
Calculates the cost to complete for:
Project:
1002HOTEL
Task:
01
Account Group:
LABOR
Cost Code:
01313
Inventory Items:
all
and returns the value in the default currency.
Result
1,000,000.00

Cell references have been used for the argument values