Functions in the Targit Syntax

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 (1st to 3rd) or all.

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

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.