1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
  4. CURRENTVERSION

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.

Syntax

CURRENTVERSION(Line item)

Arguments

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.

Syntax example

CURRENTVERSION(Net profit)

In this example, the formula returns the value from the current version for the Net profit line item.

Constraints

  • 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

Examples

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