GETMEASURE

The GETMEASURE function can be used to select data from a native measure based on its index. It should be used with an aggregate function like SUM or AVERAGE.

Syntax#

GETCOLBETWEENPERIODS(index, type)

Arguments#

index– Order of the native measure in the AC/PY/PL/FC bucket. Required.

type– Can be AC/PY/PL or FC. Required.

Example#

GETMEASURE(1, "AC")
//Returns the first native measure in the AC bucket

GETMEASURE(2, "PY")
//Returns the second native measure in the PY bucket