Total is used to generate the sum of a numeric column and display it at the end of the report. If a Break-On has been specified, Total will also display subtotals at each break point.
Total COLUMN
Total will accumulate the value of each column being totaled, and display the result at the end of the report.
If a Break-On has been specified, Total will also output subtotals at each Break-On. Note in the examples that the Break-On and Total columns can be different.
The final total appears at the end of the report, and is identified by three asterisks (***) in the leftmost column of the report. To substitute an option for the three asterisks, refer to Grand-Total.
Any number of columns can be totaled in the report. Total can be used with the modifier DET-SUPP (detail suppress) to create reports with only total values.
This command will generate a report in which the total of the BALANCE column will appear at the bottom of the report.
Sort CUSTOMERS By ST COMPANY ADDRESS Total BALANCE
In this report, a total of the column OUTSTANDING_BAL appears at the bottom. In addition, a subtotal for the column will be generated for each company.
List INVOICES By COMPANY Break-On COMPANY Total OUTSTANDING_BAL