The NEXTVERSION function evaluates the given expression using the next version.

For example, you can use the NEXTVERSION function to make comparisons between data from different versions of a plan.


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

The NEXTVERSION function returns a result of the same data type as the Expression argument.

NEXTVERSION(Operating costs)

In this example, the formula returns the value from the next version of the Operating costs 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 next version of Actual is Forecast. If there is no next version, the function returns a blank value or 0.

The result cell that you use the NEXTVERSION 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 Forecast Revenue Costs line item uses the NEXTVERSION function to retrieve the value of Revenue Costs from the Forecast version, which is the next version.

Jan 21Feb 21Mar 21
Revenue Costs12,45713,98713,483
Salary Costs27,95028,00022,765

Forecast Revenue Costs

NEXTVERSION(Forecast Revenue Costs)