PROJECTBUDGETAMOUNT

Overview

The PROJECTBUDGETAMOUNT function calculates the original budgeted amount of one or more project(s) and task(s).

This function is a part of the Project Management module.

CODE

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

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

Arguments	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 currency (default = FALSE)

CODE

=PROJECTBUDGETAMOUNT("Demo", "Planning" , "", , , "", FALSE)

Description:

Calculates the original budgeted amount of all tasks for the Planning projects and return the value in the default currency.

Result:

12200