In this article
The expression model offers functions that accept different types of expressions as arguments, including type conversion, aggregation, and ranking.
The expression model supports a set of functions. Available functions are listed below.
Most of the functions accept arbitrary expressions (of appropriate type) as arguments. Special cases include:
Type argument (for type conversion function)
Recoding definition
Level reference (for aggregating functions)
Hierarchy reference (for aggregating functions)
Ranking criteria (for ranking functions)
The following mnemonics are used in function descriptions:
a, a1, a2, etc - exressions of any type (or a type specified in comments)
x, x1, x2, etc - expressions of numeric type (integer or real)
n, n1, n2, etc. - expressions of integer type
b, b1, b2, etc. - expressions of boolean type
s, s1, s2, etc. - expressions of string type
d, d1, d2 - expressions of date/time type