Search

PREVIOUSVERSION

Returns the value from the previous version.

Syntax

PREVIOUSVERSION(x)

where:

  • x: Number, Boolean, date, time period, list item, text

Format

Input Format Output Format

x: Number, Boolean, date, time period, list item, text

Matches the data format used by argument x

Arguments

The function uses the following arguments:

  • x: Number, Boolean, date, time period, list item, text

Back to Top

Constraints

The function has the following constraints:

  • Result formatting must match source 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 model is configured for three versions: Budget, Actual, and Forecast, in that order:

The Budget version has data entered for number-formatted Cost of Goods line item:

We can use PREVIOUSVERSION in a number-formatted result line item to show the Budget Cost of Goods when the Actual version is the page selection:

Budget Cost of Goods = PREVIOUSVERSION(Cost of Goods)

Back to Top

Similar functions