TARGIT Calculations Functions

TARGIT author

January 07, 2025 11:57

Here is a list of available functions.

Function	Description
Sum	Summarizes the values in the reference range. Example: sum(d-1, 0, m1)
Count	Counts the number of cells in the reference range, except cells with null (blank) values. Example: count(all, 0, m1)
Allcount	Counts the number of cells in the reference range, regardless of null or not-null values. Example: allcount(all, 0, m1)
Max	Returns the maximum value in the reference range. Example: max(all, 0, m1)
Min	Returns the minimum value in the reference range. Example: min(all, 0, m1)
Stdev	Returns standard deviation of values in the reference range. Example: stdev(d-1, all, m1)
Avg	Returns average for values in the reference range. Example: avg(d-1, all, m1)
Median	Returns the median for values in the reference range. Example: median(d-1, all, m1)
Rankasc	Returns the rank, ascending order, for values in the reference range. Example: rankasc(d-1, all, m1)
Rankdesc	Returns the rank, descending order, for values in the reference range. Example: rankdesc(d-1, all, m1)
Percentile	Returns the percentile threshold for values in the reference range. Example: percentile(d-1, all, m1, 0.25)
Rowname	Returns 1 (true) if dimension member on row matches string. Example: rowname("Germany")
Colname	Returns 1 (true) if dimension member on column matches string. Example: colname("JEANS")

The general usage is:

Function(cell range columns, cell range rows, measure range)

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

'measure range' can be a single measure like m1 or a range of measures like m1:m2. (1^st and 2^nd) or all.