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.
Note
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.
To make a calculation, open the Settings dialog box.
For more information: Using the Dialog Box with Settings for the List
The Calculation tab page is only visible if calculations are specifically permitted for your application.
Choose the Calculation tab page.
All columns for which you can make calculations are then listed.
In the row for the required column, choose one of the following options from the dropdown list box for the Calculation column:
Specify calculation type
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 |
Mean value |
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.
Apply these settings to the list.
The result of the calculation is usually displayed in an additional row below the entries. 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; this means a results row is displayed for each unit.