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.

...

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.

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.