PROJECTFORECASTREVISEDAMOUNT

Overview

The PROJECTFORECASTREVISEDAMOUNT function calculates the revised forecasted amount of one or more project(s) and task(s).

Syntax

CODE

=PROJECTFORECASTREVISEDAMOUNT(Connection, Project, Revision, Task, AccountGroup, CostCode, InventoryItem, FromPeriod, ToPeriod)

Arguments

The PROJECTFORECASTREVISEDAMOUNT 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
`Revision`	Required	The Forecasted Review 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
`FromPeriod`	Required	Beginning Financial Period in MM-YYYY format
`ToPeriod`	Required	Ending Financial Period in MM-YYYY format

Example

CODE

=PROJECTFORECASTREVISEDAMOUNT("Demo","BUDGETBYM","2","01", "MATERIAL",, "AACOMPUT01","03-2019","03-2019")

Description

Calculates the revised forecasted amount for revision number 2 of the forecast of in the BUDGETBYM project (filtered on task=01, account group=MATERIAL, inventory item=AACOMPUT01, and the third financial period of 2019).

Result

400.00