The Average() function calculates the average of a list of numbers, date times or duration.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns number, datetime or duration that is the average of the given values.

Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries.


Average(List(values) or [field] of [list])

Average(List(1, 3, 6, 2)) => Result: 3

Average([Products.Price] of [Products]) => Result: average Price-value of all products in the list [Products]




list of numbers datetimes or durations.

The list of values for which the average is calculated. The values can be either numbers, datetimes or durations.

Last updated