TSPrevious function

The TSPrevious function records the supplied argument and returns the last argument it was passed.

Syntax

TSPrevious(value int) 
returns int;

TSPrevious(value smallfloat) 
returns smallfloat;

TSPrevious(value double precision) 
returns double precision;

TSPrevious(value datetime year to fraction(5)) 
returns datetime year to fraction(5);
value
The value to save.

Description

Use the TSPrevious function within the Apply function.

TSPrevious function is useful in comparing a value in a time series with the value immediately preceding it. The TSPrevious function can take parameters that are columns of a time series. Use the same parameter format that the Apply function accepts.

Returns

The value previously saved. The first time TSPrevious is called, it returns NULL.

Example

See the example for the TSCmp function.