Date: Fri, 29 Mar 2024 02:56:30 -0700 (PDT) Message-ID: <15586031.499.1711706190289@wiki.srpcs.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_498_46314253.1711706190289" ------=_Part_498_46314253.1711706190289 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Total is used to generate the sum of a numeric column and display it at = the end of a report generated through Run_Report. If a Break-On has been sp= ecified, Total will also display subtotals at each break point.
Total COLUMN
Total will accumulate the value of each column being totaled, and displa= y the result at the end of the report. If a Break-On has been specified, To= tal 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 lef= tmost 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 r= eports with only total values.
/* This command wi= ll list all CUSTOMERS by order of state, putting a break between each state= . At each break, the TOTAL invoice balance for all customers in that state wi= ll be displayed. A Grand-Total will be displayed at the end of the report. */ stmt =3D 'LIST CUSTOMERS CUSTOMER_NAME BY STATE BREAK-ON STATE ' stmt:=3D 'TOTAL INVOICE_TOTAL' Run_Report("",stmt)