The avg(...) function has only one variation, not counting syntax variations. It computes the average of a list of numbers ignoring null values. This function will only return null if all input values are null. The result is always a Float value. As an example, the result of avg(5, 0, 7) is 4, but the result of avg(5, null, 7) is 6.
Syntax:
avg( list-of-numbers )
first-number.avg( list-of-numbers )
Parameter |
Description |
list-of-numbers |
A comma separated list of Integer and/or Float values. |
first-number |
The first number which would be in the list-of-numbers. |