Skip to main content

Expression syntax for calculated formulas


Expression syntax for calculated formulas

The syntax for expression in calculated labels is virtually the same as for chart expressions, with a few exceptions:

  • With no dimensions to iterate over, the chart aggregation functions will essentially behave as if used in chart expressions with the total qualifier in front of all field names. The total qualifier is thus optional and has no special meaning in calculated formulas. The set definitions work just as in chart expressions, i.e. they cause aggregations over a selection different than the current one.

  • In a calculated formula, field names may optionally be used without an enclosing aggregation function. In this case only will be used as an aggregation function.


= Currency

is equal to

= only(Currency)