SUM

Generates a total sum of a specified attribute.

Syntax

SUM file-specifier attribute-name {item-list} {selection-criteria} {USING file-specifier} {macro-call} {(options}

Refer to Sentence Structure for descriptions of these parameters.

STAT

Use the STAT command if you need a count of items and an average.

Examples

In the first example, all items in the file are specified because no selection criteria are present.

:SUM GUESTS BILL-TOTAL

TOTAL OF Bill Total IS: $3,639.99

In the second example, a selection criterion is specified.

:SUM GUESTS WITH BILL-TOTAL > "240.00" BILL-TOTAL

TOTAL OF Bill Total IS: $772.86