You can add a version formula to a model. The version formula applies to the whole model, wherever the Versions dimension is applied. You would typically use a version formula for variance calculations.

To add a version formula to a model:

  1. In the model settings bar, click Versions.
  2. In the Formula cell for the version, type the formula. The formula applies to number-formatted line items only. Line items with other types of formatting are left blank.
    In the example below, formulas calculate the Variance, and the Variance %.

ActualSwitchoverFormula
ActualYes

Budget


Variance

Actual - Budget
Variance %

IF Budget > 0 THEN 100 * (Actual - Budget) / Budget ELSE 100 * (Budget - Actual) / Budget
Forecast
Apr 14

If the formula is incorrect a warning message is displayed. Check line item names are entered correctly, and the correct syntax is used for the formula. Learn more in IF THEN ELSE and Operators and Constants.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.