CUMULATIVE

CUMULATIVE

Top  Previous  Next

 

The CUMULATIVE field qualifier keyword displays the cumulative value of a field.

 

 

Format

 

CUMULATIVE field {field.qualifiers}

 

where

 

fieldis the field or evaluated expression to be displayed.

 

field.qualifiers are other field qualifying keywords

 

 

The CUMULATIVE field qualifier keyword is placed before the field name to which it applies and causes the query processor to report the cumulative value of the field. A total line is also produced. Used with breakpoints, the CUMULATIVE keyword will also report the total value of the field at each breakpoint.

 

The CUMULATIVE keyword operates only on numeric data. Non-numeric values are ignored.

 

 

Example

 

The command

 

LIST INVOICES TOTAL VALUE CUMULATIVE VALUE CUSTOMER.NAME WITH NO AMT.PAID

 

would produce a display such as that below in which the total value of the VALUE field is included at the end of the report.

 

LIST INVOICES TOTAL VALUE CUMULATIVE VALUE CUSTOMER.NAME WITH NO AMT.PAID

Invoice  ...Value  ...Value  Customer...................

74529    £1712.43  £1712.43  J McTavish

74273      £95.23  £1807.66  County Newspapers

63940     £141.00  £1948.66  R Bryant

74993       £9.29  £1957.95  Write Right Stationery

        ========  ========

        £1957.95  £1957.95

4 records listed.