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 July 8, 2024