Average

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.

Syntax

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]

Parameters

Name	Type	Required	Description
values	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.