Functions in the Targit Syntax

TARGIT author

January 15, 2021 13:25

Here is a list of available functions.

Function	Description
Sum (default)	Summarizes the measures in the cell ranges. (cells defaults to sum)
Count	Counts the number of cells in the cell range having any measure value. (normally used for counting dimension values)
Allcount	Counts the number of all cells in the cell range regardless of measure values.
Max	Returns the maximum value for measures in the cell range.
Min	Returns the minimum value for measures in the cell range.
Stdev	Returns standard deviation for measures in the cell range.
Avg	Returns average for measures in the cell range.
Median	Returns the median for measures in the cell range.
Rankasc	Returns the rank, ascending order, for measures in the cell range.
Rankdesc	Returns the rank, descending order, for measures in the cell range.

The general usage is:

Function(cell range x, cell range y, measure list (m1;m2;m3… etc).

Cell range can be just a single value like d1 or a range like d1:d3 (1^st to 3^rd) or all.

Measure list can be a single measure like m1 or a list of measures like m1;m2. (1^st and 2^nd).