The CURRENTVERSION function returns the value from another line item for the version that is set as Current in a model.
For example, you can use the CURRENTVERSION function to compare data between versions.
|Number, Boolean, date, time period, list, or text
|The line item to return the value from the current version for.
The CURRENTVERSION function returns a result of the same data type as the Line item argument.
In this example, the formula returns the value from the current version for the Net profit line item.
- You can only use the CURRENTVERSION function if a version is set as Current in Versions in the model settings bar.
- You can only use the CURRENTVERSION function if all line items referenced in a formula use Versions as a dimension.
In this example, an income statement module has line items on rows, the Products list on columns, and versions on pages. The Budget version displays as a page selector.
The model that contains the module has three versions: Budget, Actual, and Forecast. The Actual version is set as Current.
The formula uses the CURRENTVERSION function to show the difference between budget and actual data for Cost of Goods.
|Cost of Goods
Cost of Goods (Actual)