1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. NEXT

Returns a value from the next period.

Syntax

NEXT(x) 

where:

  • x: the value to return

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, or text-formatted line item

Constraints

The function has the following constraints:

  • Result formatting must match source formatting.
  • If source is list-formatted, result must be list-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 time period-formatted for months, result must be time period-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 number-formatted Net Profit line item shows calculated net profit each month and for the forecast version switchover is set at Mar 14. We can use the NEXT function in the number-formatted Forecast Profit Change result line item against the Net Profit source to track projected month-by-month profit changes for the forecast version:

Back to Top

Similar functions