average

Returns the average value of the selected data items.

Syntax

average ( < currentMeasure|numeric_expression > within set 
set_expression )
average ( < currentMeasure|numeric_expression > within < 
detail|aggregate > expression )

Example

average ( Sales )

Result

Returns the average of all Sales values.