MIN
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 minimum value per group. MIN can be applied on any data type.
Syntax
MIN ( 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] Minimum of column. |
[2] Get the minimum value by country. |
[3] Get the minimum value mixed with nulls, grouped by country. |