AVG
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 aggregate function calculates the average of a set of values.
AVG calculates the average of an INT or FLOAT column. The data type of the result is always a FLOAT (Since: CELONIS 4.5).
Syntax
AVG ( 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] Calculating the average of four small integers. |
[2] Calculating the average of values grouped by country. |
[3] Calculating the average of values mixed with nulls, grouped by country. |