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:

• Average

• AverageA

• CountA

• Max

• Min

• Product

• Sum

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]