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.

CURRENTVERSION(Line item)

ArgumentData typeDescription
Line itemNumber, Boolean, date, time period, list, or textThe 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.

CURRENTVERSION(Net profit)

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.


ChocolatesSoursTaffyFudge
Cost of Goods190,000150,000250,000180,000

Cost of Goods (Actual)

CURRENTVERSION(Cost of Goods)

198,000140,433250,670203,005