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) |