Previous

Previous Function

Shifts the specified vector down by one. Useful for comparing the current value and the previous value in a vector.

Syntax

Previous(vector Column)

Arguments

Argument	Description
vector Column	A column to shift down by one

Examples:

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

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