Average is a mathematical function that returns the average of a group of numeric values, rows, columns, or cells. Average excludes #MISSING and #ERROR cells when obtaining the average.
Note: | The calculation does not include missing values regardless of whether they are suppressed or not. |
The function syntax:
Average(arguments) or Avg(arguments)
where arguments is one or more of the following:
Argument | Description |
|---|---|
numeric | A numeric value. For example, Average (10, 20, 30) returns the value 20. Numeric values can include decimals and negative values. |
row, column, or cell reference | A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax: GridName.GridElement[segment(range)].Property For example Avg(Grid1.row[4(3:5)]) returns the average of form grid1, row 4, range 3 through 5. |
function | An embedded function |
Examples:
The following expression returns the value 20:
Avg( 10, 30, 20)
The following example returns the average of all numbers that are part of three aggregate rows:
Average( row[1], row[6], row[8] )
The following example calculates the average of three aggregate columns; E, G, and I. The calculation produces three numbers and calculates the average of the three numbers:
Avg(column[E].avg, column[G].avg,column[I].avg)
The following example calculates the average of aggregate row 3 and divides the average by 100:
Avg(row[3])/100