1. Modeling
2. New modeling experience
3. Formulas
4. Add version formulas to a model

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 %.
 Actual Switchover Formula Actual Yes 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 may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.