Icon

    This summary provides overview of all formulas that can be used in reports or data sets (predefined indicators).
    If you are searching for transformation scripting during data import, see Developer documentation.

    Indicators and codes

    Each dataset indicator is specified by its unique code starting with M_ (M as Measure). Accessing the calculated indicator's value is possible by typing this code directly into the formula. For example:

    Another way how to get the value of the indicator is to use the value() function:

    Icon

    Strings must be always enclosed by apostrophes: 'L_NAME'.

    Both examples have the same result.

    Drill-down (members) aggregation

    Members aggregation determines the way how to count values in the case that exists more records for one selected member in a single time unit. Aggregation type is specified by adding the appropriate suffix to the indicator's code. When not specified, the SUM aggregation is applied.

    Suffix

    Description

    Example

    @SUM

    Calculates the sum of all values for the selected drill-down attribute

    M_NAME@SUM

    @MIN

    Calculates the minimum of all values for the selected drill-down attribute

    M_NAME@MIN

    @MAX

    Calculates the maximum of all values for the selected drill-down attribute

    M_NAME@MAX

    @AVG

    Calculates the average of all values for the selected drill-down attribute

    M_NAME@AVG

    @MEDIAN
    Calculates median of all values for the selected drill-down attribute
    M_NAME@MEDIAN

    @DC

    Calculates the distinct count of all values for the selected drill-down attribute

    M_NAME@DC

    Counting of level members

    Each drill-down level is represented by particular members, for example the level City contains members like Berlin, Paris, New York etc. To get the count of these members, use the following syntax:

    Next Steps