Previous Function

This function returns a column value from one of the preceding rows. It allows transformations in combination with other functions concerning values from several rows. Input consists of one input field.

Parameters

Offset Indicates the number of rows before the current row the input value is taken from (Default: 1).
Default This value is used if the actual RowNumber is less or equal to the Offset parameter, i.e., used at least for the first row.

Updated September 27, 2022