average
Returns the average value of selected data items. Distinct is an alternative expression that is compatible with earlier versions of the product.
Syntax
average ( [ distinct ] expression [ auto ] )
average ( [ distinct ] expression for [ all|any ] expression { ,
expression } )
average ( [ distinct ] expression for report )Example
average ( Sales )Result
Returns the average of all Sales values.