SUM

SUM

Top  Previous  Next

 

The SUM verb reports the total of the values in named fields.

 

SUM {DICT} file.name

{USING {DICT} file.name}

field.name {field.qualifier} ...

{selection.clause}

{record.id...}

{FROM select.list.no}

 

 

Example

 

SUM INVOICES BALANCE WITH NO PAYMENT.DATE

 

This command the BALANCE field of records on the INVOICES file for which the PAYMENT.DATE field is null.