For example, you can use the CURRENTVERSION function to compare data between versions.
|Line item||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.
Related Anaplan functions
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||190,000||150,000||250,000||180,000|
Cost of Goods (Actual)