Functions reference

You can define which functions will be available on the formula bar.

Table 1: Categories of functions

Category

Description

Character

Manipulates character strings

Aggregate

Aggregate functions are implemented in the definition of a measure.

Aggregates data (for example, by summing or averaging a set of values)

Date and Time

Returns date or time data

Numeric

Returns numeric data

Logical

Returns true or false

Miscellaneous

Functions that do not fit in any other category