Next

Next Function

Shifts the specified vector up by one. Useful for comparing the current value and the next value in a vector.

Syntax

Next(vector Column)

Arguments

Argument	Description
vector Column	A column to shift up by one

Examples:

Select([FusionTestTable.DateTimeCol] as beginDate,Next(([FusionTestTable.DateTimeCol]-1))as expireDate)

Return a table with a column containing the current values and a column containing the next values.