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.
Syntax
=PROJECTBUDGETAMOUNT(
Connection,
Project,
Task,
AccountGroup,
CostCode,
InventoryItem,
UseProjectCurrency
)
Arguments
The PROJECTBUDGETAMOUNT function uses the following arguments (see our article on Filtering Velixo functions):
Arguments | 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
=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