Name

offset — Return the offset (year in the future) for the current calculation.

Syntax

offset()
              

The OFFSET function has no arguments.

Description

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.

Examples

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