4 Functions

The TOTAL Function

The TOTAL function returns the running total for the specified expression in a TOTALS ON statement. The value returned is the cumulative value since the header statement block, containing the TOTALS ON statement, was last invoked by a break condition.

TOTAL (level, sequence)

The parameters are:

level
A numeric expression evaluating to an integer from 0 to 9. It associates the TOTAL function to a TOTALS ON statement in a header with the same level number. If level equals zero, the TOTAL function will reference the GRAND TOTALS ON statement.
sequence
A numeric expression evaluating to a positive integer. It corresponds to the sequential position of the desired expression in the TOTALS ON statement.
An example of this function follows.


220  HEADER 3
230    TOTALS ON Qty*Price
240  TRAILER 3 USING P_trail3;TOTAL(3,1)

Eloquence Report Manual - 19 DEC 2002