Using totals
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.