Model builders can set up reports to compare the variance between versions in a model. Set up variance reports without versions if you don't 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 Item | Formula |
| Actual | Module.Line Item[SELECT: VERSIONS.Actual] |
| Budget | Module.Line Item[SELECT: VERSIONS.Budget] |
| Variance | Budget – 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 Item | Formula |
| Data | COLLECT() |
| Actual | Module.Line Item[SELECT: VERSIONS.Actual] |
| Budget | Module.Line Item[SELECT: VERSIONS.Budget] |
| Variance | Budget – Actual |
| Variance % | Variance / Actual |
