The PREVIOUSVERSION function evaluates the given expression using the previous version.
For example, you can use the PREVIOUSVERSION function to make comparisons between data from different versions of a plan.
|Expression||Number, Boolean, date, time period, list, or text||The expression to return the value from the previous version for.|
The PREVIOUSVERSION function returns a result of the same format as the Expression argument.
In this example, the formula returns the value from the previous version of the Bonus line item.
The order of versions is from top to bottom in Versions in the model settings bar.
For example, if your model's versions are ordered Budget, Actual, and Forecast, the previous version of Actual is Budget.
The result cell that you use the PREVIOUSVERSION function in must use Versions as a dimension.
In this example, an income statement module has line items on rows, time on columns, and versions on pages. The model has three versions: Budget, Actual, and Forecast, in that order. The page selector is set to the Actual version.
The formula in the Budget Cost of Goods line item uses the PREVIOUSVERSION function to retrieve the value of Cost of Goods from the previous version.
|Jan 21||Feb 21||Mar 21|
|Cost of Goods||198,734||236,761||200,459|
Budget Cost of Goods