The following functions require the use of the 'Aggregate' or 'AggregateAll' prefixes in the following format.
'Aggregate' performs an aggregation of the values for a single instance whereas 'AggregateAll' joins instances to their parent group(s). An example of their use follows.
Function
Description
Example
average
Calculates the average of the values.
average(values)
count
Counts the number of entries.
count(values)
join
Concatenates all values and separates them with a delimiter. A format can specified to present numeric values in a desired format.
join(values, format, delimiter)
joinDistinct
Concatenates unique values and separates them with a delimiter. A format can specified to present numeric values in a desired format.
joinDistinct(values, format, delimiter)
max
Determines the maximum value from a list of values.
max(values)
min
Determines the minimum value from a list of values.
min(values)
orderAsc
Orders a list such that the elements are in an ascending order.
orderAsc(values)
orderDsc
Orders a list such that the elements are in a descending order.
orderDsc(values)
sum
Returns the sum of all values.
sum(values)
first
Determines the first value from a list of values.
first(values)
last
Determines the last value from a list of values.
last(values)