Returns the average (mean) of all the input values.
Function
avg(input)Arguments
| Argument | Data Type |
| input | numeric list |
|---|---|
| result | decimal |
Comments
Returns the average of all the input values. The input data can be any numeric data type. If the input is an integer data type, then the result will have a decimal data type.
Note: it is also possible to calculate the average of values in a report without writing a calculation by using column totals or by summarising a report relationship.
Examples
The following calculation assumes it is run in the context of a hypothetical purchase order record that has multiple items, each with a numeric 'weight' field. It returns the average of the weight values.
avg([Items].[Weight])