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.
Example:
= Currency
is equal to
= only(Currency)