Using totals

Top  Previous  Next

In the dynamic mode of the "Table" object, the following total functions are supported:

 

Function

Parameters

Description

Sum

TableCell cell

Returns the sum of the values contained in cell.

Min

TableCell cell

Returns the minimum from the values contained in a cell.

Max

TableCell cell

Returns the maximum from the values contained in a cell.

Avg

TableCell cell

Returns the average of the values contained in a cell.

Count

TableCell cell

Returns the number of rows, contained the specified cell.

 

In an ordinary printing mode (not dynamic) these functions will not work.

 

In order to use the total function, place it in the cell of the table. For example, the following function calculates the sum of the values contained in a cell named "Cell1":

 

[Sum(Cell1)]

 

During this, all the cells located higher and on the left of the current cell (in which we are calculating the sum) are analyzed.