Calculations on All Items of the Table

Use

You want to calculate a total, the average value, or the number of items for all values in a column of your table.

Prerequisites

You created a table node and use the Data tab to read your internal table.

Procedure

  1. Go to the Calculations tab.
  2. In the Operation column select the desired operation.
  3. If you selected Total or Average Value as operation, in the Field Name enter a field (usually a field of the work area) that you want to use to execute the operation.

    You want to calculate the total of all prices of an airline (assumed that the airline uses only one currency!). Read the data from the internal table FT_SFLIGHT with line structure SFLIGHT line by line into the work area WA_SFLIGHT . To sum up the price, enter WA_SFLIGHT-PRICE as Field Name .

  4. As Target Field Name enter a field with the same data type as the field from the last step. This can be a field from the global definitions or from the form interface.

    Define a global field SUM_SFLIGHT of type SFLIGHT . As target field enter SUM_SFLIGHT-PRICE .

  5. As calculation event specify After Loop or Before Loop .

    For the operations Total or Average Value use After Loop . It is not possible to use the event Before Loop to display a total of the table items to come, because the calculation event refers to one loop pass only and not to the entire loop.

  6. To initialize the target field before table output, mark the checkbox in the Initialization column.
  7. If the target field refers to a currency or quality field, you must assign the correct currency or unit to this field before displaying it; this is then valid for the entire table output. To do this, create a program lines node.

Field SFLIGHT-PRICE in the Dictionary refers to the currency field SFLIGHT-CURRENCY . If your target field is SUM_SFLIGHT-PRICE (as above), you must assign the correct currency to field SUM_SFLIGHT-CURRENCY before displaying SUM_SFLIGHT-PRICE . If the reference field is stored in a different table, refer to Displaying Fields That Refer to Currencies or Quantities.

Result

You display the result of your calculation in the footer. When you use the Number operation to consecutively number the items of the table, display the target field within the main area.