====== Total ======

 


 
==== Description ====
 
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.
 
==== Syntax ====
 
**Total** COLUMN
 
==== Remarks ====
 
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.


==== Examples ====

This command will generate a report in which the total of the BALANCE column will appear at the bottom of the report.
 
<code>
Sort CUSTOMERS By ST COMPANY ADDRESS Total BALANCE
</code>

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.

<code>
List INVOICES By COMPANY Break-On COMPANY Total OUTSTANDING_BAL
</code>