Page History
...
If Break-On has been specified, AVERAGE will also output sub-averages at each Break-On. The Break-On and Average columns can be different. The final average 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 averaged in the report. Average can be used with the modifier DET-SUPP (detail suppress) to create reports with only average values.
Example
| Code Block |
|---|
/* Print all Customers displaying the Customer Name and Invoice Total fields and averaging the Invoice Total */
stmt = 'LIST CUSTOMERS CUSTOMER_NAME AVERAGE INVOICE_TOTAL' |
...
Run_Report('',stmt) |
...
/ |
...
* This command will list all CUSTOMERS by order of state, putting a break between each state. At each break, the average invoice balance for all customers in that state will be displayed. An average of all invoice balances will be displayed at the end of the report. */
|
...
stmt = 'LIST CUSTOMERS CUSTOMER_NAME BREAK-ON STATE |
...
AVERAGE |
...
'
stmt:= 'INVOICE_TOTAL BY STATE' |
...
Run_Report("",stmt) |
