MAX
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
This function calculates the maximum value per group. MAX can be applied on any data type.
Syntax
MAX ( table.column )
NULL handling
NULL values are ignored, meaning that they do not influence the result. If all values of a group are NULL, the result for this group is also NULL.
Examples
[1] Maximum of column. |
[2] Get the maximum value by country. |
[3] Get the maximum value mixed with nulls, grouped by country. |