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:
- In the model settings bar, click
- 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 %.
|Variance||Actual - Budget|
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.