PROJECTCOSTTOCOMPLETE

Overview

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

CODE

=PROJECTCOSTTOCOMPLETE(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, UseProjectCurrency)

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

Argument	Required/ Optional	Description
`Connection`	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
`UseProjectCurrency`	Optional	`TRUE`/`FALSE` value indicating if the amount should be returned in the project's defined currency (default = `FALSE`)

Assuming the following project information within the ERP:

CODE

=PROJECTCOSTTOCOMPLETE("ACE","1002HOTEL","01", "LABOR", "01313",, FALSE)

Description

Calculates the cost to complete for:

and returns the value in the default currency.

Result

1,000,000.00

Cell references have been used for the argument values