Sum

Sum is a mathematical function that returns the summation of a group of numeric values, rows, columns, or cells.

Syntax:

Sum(arguments)

where arguments is one or more of the following values:

Argument

Description

numeric

A numeric value. For example, Sum(10,20,30) returns the value 60.

Numeric values can include decimals and negative values. See Numeric Arguments.

row, column, or cell referenc

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. See Row, Column, or Cell Reference Arguments.

function

An embedded function.

See Mathematical Functions.

Examples:

Return the value 30:

sum(10,20)

Return the sum of three rows:

sum(row[1],row[6],row[8])

Calculate the sum of three aggregate columns:

sum(column[E], column[G], column[I])

Calculate the sum of two columns which are located on different grids:

sum(grid1.col[E],grid2.colmn[E])