Search Results for

    Show / Hide Table of Contents

    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.

    Back to top © 1998-2025 Copyright Fast Reports Inc.