Making Calculations

Use

You can make various calculations in columns that contain numeric values:

  • Total

    Add all values in the column that have the same unit of measure

  • Maximum

    Find the highest value for the column

  • Minimum

    Find the lowest value for the column

  • Average value

    Calculate the mean value of all values

You specify a maximum of one calculation type for each column. The result of the calculation is displayed in a separate row, called the results row.

Procedure

  1. To make a calculation, open the dialog box Settings (see Using the Dialog Box with Settings for the List).

    The Calculation tab is only visible if calculations are specifically permitted for your application.

  2. Choose the Calculation tab.

    All columns for which you can make calculations are then listed.

  3. In the row for the required column, choose one of the following options from the dropdown list box for the Calculation column:

    To achieve this

    select the entry

    Add all values in the column that have the same unit of measure

    Total

    Find the highest value for the column

    Maximum

    Find the lowest value for the column

    Minimum

    Get the mean value of all values

    Average Value

  4. To delete the calculation of a column, select the relevant entry in the list and choose the entry None in the dropdown list box of the column Calculation.

  5. Apply your settings to the list.

Result

The result of the calculation is usually displayed in an additional row below the entries. If the calculation is performed using incompatible units, such as kilograms and liters or several currencies, a result is calculated for each unit (a line with an average is displayed for each unit).