Calculations

Use

Using table output you cannot only display items of the internal table but also include calculations on this data into the output procedure and then display results or intermediate results with the table.

Prerequisites

You are familiar with table output.

Features

When executing calculations during table output, you must distinguish between two cases:

  • To calculate values that refer to a single unit or currency, use the Calculations tab of the table node. This node allows you to flexibly integrate the operations Total, Average Value and Number into your table output.
  • To calculate values whose results refer to different units or currencies, you must include program lines nodes in the navigation tree to execute the calculations manually. See: Summing Up Different Currencies.

This section deals with the automatic calculations provided by the Calculations tab.

Activities

For a practical introduction to automatic calculations take a look at the examples. The examples use one operation to explain the options that automatic calculations offer. To use automatic calculations you proceed as follows:

  1. Define an additional global field, the target field, which you need to display the result of the operation.
  2. On the Calculations tab of the table node select an operation first, then a field (that is, a column of the table), for which to execute the operation, and specify the calculation and initialization events.
  3. Depending on whether you execute a calculation on all items of the table or on items of a sort level, display your result either in the footer or at the beginning or end of a sort level.