OFFSET Function

Modified on 2011/08/03 00:41 by Chad Lowe (CTS) — Categorized as: Uncategorized

OFFSET( <value>, <periods> )

Gets the value offset by the specified number of periods.

Function Parameters
ParameterDescription
<value>The value to look up.
<periods>The number of periods to look back or forward.

Note: A negative <periods> value retrieves previous values, whereas a positive <periods> retrieves forward values (looks ahead).



Back to the Scripting Function Reference