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]