Sum

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:

Sum (arguments)

where arguments is expressed by one or more of the following arguments:

Argument

Description

numeric

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.

row, column, or cell reference

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.

function

An embedded function. For a list of mathematical functions, see Mathematical Functions.

Examples:

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])