PREV

PREV(field)[source]

Returns the previous value of a field within a table.

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

Parameters:

field (Operand) –

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

Supported types:

  • ANY

Return type:

Formula

Returns:

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

Supported types:

  • ANY