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.
|Expression||Number, Boolean, date, time period, list, or text||The 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.
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 21||Feb 21||Mar 21|
Forecast Revenue Costs