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

●      Mean 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.

If the calculation is made using incompatible units, such as units of measure in kilograms and liters, or different currencies, a total appears for each unit.

Procedure

...

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

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

       2.      Choose the Calculation tab page.

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:

Specifying the Calculation Type

To...	Select
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
Calculate the mean value of all values	Mean Value

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

       5.      Apply your settings to the list.

Result

The result of the calculation is displayed in an additional row below the entries. If the calculation is made using incompatible units, such as kilograms and liters, or using different currencies, a result is calculated for each unit; this means a results row is displayed for each unit.