1. Modeling
  2. Dimensions
  3. Versions
  4. Variance reports without versions

Model builders can set up reports to compare the variance between versions in a model. Set up variance reports without versions if you do not want to increase the size of your model.

Set up variance reports with line items

As an alternative to versions, you can create line items to calculate variance data.

For example, you can create the line items and formulas in the table below to calculate the variance between versions. In this example, use the SELECT function to return data from Actual and Budget versions in your model.

Note: You can only use the SELECT function with line items.

Line ItemFormula
ActualModule.Line Item[SELECT: VERSIONS.Actual]
BudgetModule.Line Item[SELECT: VERSIONS.Budget]
VarianceBudget – Actual
Variance %Variance / Actual

Set up variance reports with line item subsets

You can also create line item subsets to return data from line items in different modules.

For example, you can create a line item subset with the line items and formulas in the table below. In this example, use the COLLECT function in the Data line item to return data from each line item in the line item subset.

Line ItemFormula
DataCOLLECT()
ActualModule.Line Item[SELECT: VERSIONS.Actual]
BudgetModule.Line Item[SELECT: VERSIONS.Budget]
VarianceBudget – Actual
Variance %Variance / Actual