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
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)
