English

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.

PREVIOUSVERSION(Expression)

Arguments

ArgumentData typeDescription
ExpressionNumber, Boolean, date, time period, list, or textThe expression to return the value from the previous version for.

The PREVIOUSVERSION function returns a result of the same format as the Expression argument.

Syntax example

PREVIOUSVERSION(Bonus)

In this example, the formula returns the value from the previous version of the Bonus line item.

Additional information

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.

Constraints

The result cell that you use the PREVIOUSVERSION function in must use Versions as a dimension.

Examples

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 21Feb 21Mar 21
Cost of Goods198,734236,761200,459
Goods Sold456,987498,705460,983

Budget Cost of Goods

PREVIOUSVERSION(Cost of Goods)

200,000245,000205,000

Disclaimer

We update Anapedia content regularly to provide the most up-to-date instructions.