[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
SUM

    SUM totals expressions involving numeric fields in the active database
    file.

Syntax

    SUM [<scope>] <expN list> TO <memvar list> [FOR <condition>]
    [WHILE <condition>]

Argument

    <expN list> is the list of numeric values to SUM for each record
    processed.

    <memvar list> identifies the receiving memory variables for the SUM and
    are created at the time of execution of the command.  Existing memory
    variables with the same names are overwritten.  This list must contain
    the same number of elements as the list of expressions to SUM.

Option

    Scope: The <scope> is the portion of the current database file to
    SUM.  The default scope is ALL.

    Condition: The FOR clause specifies the conditional set of records
    to SUM within the given scope.  The WHILE clause specifies the set of
    records meeting the condition from the current record until the
    condition fails.

See Also: AVERAGE TOTAL
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson