Calculating Grand Totals 
Use
You want to calculate a grand total on the
PRICE
column of a table. This column refers to the currency field
CURRENCY
. All values of the column have the same currency.
Prerequisites
The same prerequisites as for
Examples.
Procedure
For table
BUSINESS
define a global structure to contain the result of the calculation, for example,
R_BUSINESS
. Create a
program lines node before the table node and assign to
R_BUSINESS-CURRENCY
the currency used for the price in the table.
On the
Calculations
tab fill the following fields:
Column |
Value |
Operation |
Total |
Field Name |
WA_BUSINESS-PRICE |
Target Field Name |
R_BUSINESS-PRICE |
Event |
After Loop |
Initialization |
(active) |
To display the grand total, include a table line into the footer and include a text node into this table line. In the text node, include
R_BUSINESS-PRICE
and
R_BUSINESS-CURRENCY
.
You can specify whether to display the total at the end of each page (as subtotal) or as a grand total at the end of the table. To do this, activate or deactivate the option
At Page Break
of the footer.
Result
The total appears in the footer, formatted in the currency
CURRENCY
.