Event 1 Integrator Help

Online Help

Forecast Interface - Calculation

Contents  Index

The table below identifies the formula that is used to populate either the Forecast Cost or Percent(%) field in Prolog based on data in other fields and settings of the Forecast interface.

Calculation Basis

In each case the Calculation Basis is the value of whichever Prolog Manager field that is identified by the Financial Column setting.

Formulas

Field to updateCalculation Method Formula
Percent(%) Multiply Forecast Cost = (Calculation Basis) x (Percent%)
Percent(%)Divide Forecast Cost = (Calculation Basis) / (Percent%)
Forecast Cost Multiply Percent(%) = (Forecast Cost) * (Calculation Basis)
Forecast Cost Divide Percent(%) = (Forecast Cost) / (Calculation Basis)

Examples

Financial Column Field to update Calculation MethodFormula
Actual Cost To Date Percent(%) Divide Forecast Cost = (Actual Cost To Date) / (Percent(%))
Actual Cost To Date Forecast Cost Divide Percent(%) = (Actual Cost To Date) / (Forecast Cost)
Note - If the Financial Column is "N/A", no calculation occurs.

See Also


Content updated 5/24/2011
Copyright © 2011 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.