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.