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

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. You can specify references 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.

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.

You can specify references 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 that are located on different grids:

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