Function Index

Lead

Shift a column upward.

Usage

Lead(<field>,<offset>,<default>)

field (required) A column of values to be shifted.

offset (optional) Distance, in rows, to shift. Must be an integer greater than 0. Defaults to 1 if an offset value isn’t provided.

default (optional) Default value for the first offset rows. Rows will be Null if a default isn’t provided.

Examples

Lead([Quarter], 1)
  • If Quarter has”Q1″, “Q2”, “Q3″ and”Q4″, the Lead of 1 would be”Q2”, “Q3”, “Q4” and Null