offset
offset()
The OFFSET function has no arguments.
Return the value of the offset (or year in the future) argument that is passed to the expression evaluation function. Note that 'offset' is an alias for 'year', and both functions return the same value.
Formula |
Description |
Result |
---|---|---|
offset() | Returns the year of the current calculation. | number |
lookupCurve(curveId('Yield.21.Pl'),offset) | Lookup the value of the 'Yield.21.Pl' curve for the age value returned by the offset() function. | number |