TOTAL
From CometWiki
(New page: TOTAL Syntax: TOTAL field-name[,P][;field-name{,P}][;field-name{,P}] Where: P = print a message (string) on the total line Placement: Place the TOTAL command after the REPORT comma...)
Newer edit →
Revision as of 13:14, 5 June 2009
TOTAL Syntax: TOTAL field-name[,P][;field-name{,P}][;field-name{,P}] Where: P = print a message (string) on the total line Placement: Place the TOTAL command after the REPORT command and immediately after the PRINT command containing the fields you wish to total. Discussion: The TOTAL command produces grand total, subtotals, and column totals. Follow the TOTAL command with the field-name or expression you wish to total. You can also use the optional "P" parameter to print a message or string value along with the total in the report. You can use the BREAK and TOTAL commands together without a PRINT command to produce summary reports. A summary report provides one total line each time the data in the break field changes.
Line continuation
To continue the TOTAL command to the next line, end the line with a ";" and continue on the next line.
