Aggregate Property Arguments
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 aggregate properties to a row, column, or cell reference. Aggregate properties include:
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]