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

Returns the parameter value from the Current version. The current version is defined under Versions on the Settings tab.

Syntax

CURRENTVERSION(x) 

where:

  • x: Value to retrieve.

Format

Input Format Output Format

Number, Boolean, date, time period, list, or text-formatted line item

Matches the data format used by argument x

Arguments

The function uses the following arguments:

  • x: Number, Boolean, date, time period, list, or text-formatted line item

Constraints

The function has the following constraints:

  • Result formatting must match source line item formatting.
  • If source is list-formatted, result must be formatted to the same list.
  • If source is time period-formatted, result must be formatted for the same time period. For example, if source is formatted for months, result must be formatted for months.

Excel equivalent

  • No Excel equivalent

Back to Top

Example

In this example, we have a simple Income Statement module with line items on rows, a time dimension on columns, and Organization and Versions as pages. The Actual version is defined as the current version. Switchover is applied to line items and is set at Mar 14 for the Forecast version. We can then use CURRENTVERSION with number-formatted source and result to compare the Actual version values with the Forecast version values from switchover onwards:

CURRENTVERSION(Goods Sold)      

Back to Top

Similar functions