PROJECTFORECASTREVISEDQUANTITY

Overview

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

Syntax

CODE

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

Arguments

The PROJECTFORECASTREVISEDQUANTITY 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 Forecast Revision number 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

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

Description

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

Result

1.00