Sum is a mathematical function that returns the summation of a group of numeric values, rows, columns, or cells.
The syntax for the Sum function is:
where arguments is expressed by one or more of the following arguments:
A numeric value. For example, Sum(10, 20, 30) returns the value 60. Numeric values can include decimals and negative values. For a description of numeric arguments, see Numeric Arguments. | |
A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax is: GridName.GridElement[segment(range)].property For more information, see Row, Column, or Cell Reference Arguments. | |
An embedded function. For a list of mathematical functions, see Mathematical Functions. |
The following example returns the value 30:
sum(10,20)
The following example returns the sum of three rows:
sum(row[1],row[6],row[8])
The following example calculates the sum of three aggregate columns:
sum(column[E], column[G], column[I])
The following example calculates the sum of two columns which are located on different grids:
sum(grid1.col[E],grid2.colmn[E])