Query_Lang-SystemFunctions_Aggregate_AVGAVG_AD
Created: August 02, 2022 | Updated: August 02, 2022
| Applies to version: 21
This document is no longer available beyond version 21. Information can now be found here: AVG for version 25
Parent page: System Query Functions - Aggregate Functions
Summary
Returns a (real) number whose value is equal to the average value of all of the parameters provided. Each parameter must be either a number, or a numeric string, and any number of parameters can be provided.
Syntax
AVG(N1 : Number / Numeric_String, [N2] : Number / Numeric_String, ...) : Number
Example Usage
AVG(2)
Returns 2.
AVG(7,2,3)
Returns 4.
Tips
- At least one parameter must be provided.