NEXT

NEXT(field)[source]

Returns the next value of a field within a table.

When used in a table, it retrieves the value of field from the next row. If used outside a table context or if there is no next row, the formula evaluates to an error.

Parameters:

field (Operand) –

The field whose next value is to be retrieved. If a formula is provided, PREV will evaluate it for the next row.

Supported types:

  • ANY

Return type:

Formula

Returns:

The value of field from the next row in the table.

Supported types:

  • ANY