Aggregate Property Argument
An aggregate row, column, or cell contains multiple rows, columns, or cells, respectively.
The aggregate property argument is the last argument in the following mathematical function syntax:
FunctionName(GridName.Gridelement[segment(range)].property)You apply the following aggregate properties to a row, column, or cell reference.
Table B-4 Aggregate Properties
| Properties | Description |
|---|---|
|
Average |
Returns the average of a row, column, or cell. The calculation excludes #MISSING and #ERROR values. |
|
AverageA |
Returns the average of a row, column, or cell. The calculation includes #MISSING and #ERROR values. |
|
Count |
Returns the number of values in a row, column, or cell. The calculation excludes #MISSING and #ERROR values. |
|
CountA |
Returns the number of values in a row, column, or cell. The calculation treats #MISSING and #ERROR values as zero (0). |
|
Max |
Returns the maximum value of a row, column, or cell |
|
Min |
Returns the minimum value of a row, column, or cell |
|
Product |
Returns the product of rows or columns |
|
Sum |
Returns the sum of a row, column, or cell |
When used as a mathematical function argument, the default for property is the same as the function. In the following example the default property is Average:
Average(row[2])When not used as a mathematical function argument, the default for property is sum. In the following example the default property is the sum of an aggregate row:
row[2]