Avg

Return to: Calculated Member Builder Function List

Returns the average value of a numeric expression evaluated over a set.

Syntax

Avg(«Set»[, «Numeric Expression»])

Remarks

This function requires an implicit count of the number of cells, not including empty cells. In order to force the inclusion of empty cells, the application must use the CoalesceEmpty() function. For more information about empty cells, see the OLE DB documentation.

Example

The preceding function returns the preceding value if respective Sales are 1000, 2000, and 3000.