offset(value,offset)¶
Definition¶
Object offset(Object value, Integer offset)
Description¶
Will grab the value offset from the current row. If offset==0 use current row, negative number is nth prior row, positive number is nth future row. Evaluates to null if offset is out of bounds for current table. Ex: offset(price,-1) for first row returns null, for second row returns first Row's price and for nth row returns (n-1)ths row's price
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| value | Object | |
| offset | Integer |