SUM

Generates a total sum of a specified attribute.

Syntax

SUM file-specifierattribute-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