Search

PREVIOUS

Returns the value from the previous period.

Syntax

PREVIOUS(x)

where:

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

Format

Input Format Output Format

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

Constraints

The function has the following constraints:

  • The result formatting must match the source formatting.
  • If the source is list-formatted, then the result must be formatted to the same list.
  • If the source is time period-formatted, then the result must be formatted for the same time period. For example, if the source is time period-formatted as Month, then the result must also be formatted as Month.

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 number-formatted Net Profit line item shows calculated net profit each month and is summed for quarters. We can use the PREVIOUS function in the number-formatted Month-on-Month Profit Change result line item against the Net Profit source to track profit changes for the actual version:

Month-on-Month Profit Change = Net Profit - PREVIOUS(Net Profit)

Back to Top

Similar functions