Calculating and Deleting Maximums and Minimums

Prerequisites

You can calculate a maximum and minimum for one or more columns. Maximums and minimums can **only** be calculated for
Key Figures.

If a maximum and minimum is calculated using heterogeneous units, such as kilograms and liters or several currencies, a maximum and minimum is calculated for each unit.

Procedure

Calculating Maximum / Minimum

- Select one or more columns (these must fulfill the prerequisite described above).
- Choose ®
*Maximum*/*Minimum*.

Result

Maximums and minimums are usually displayed with a yellow background in a separate line underneath the entries. If a maximum and minimum is calculated using heterogeneous units, such as kilograms and liters or several currencies, a maximum and minimum is calculated for each unit (a line with maximum / minimum is displayed for each unit).

Depending on the list, the maximum / minimum may be displayed above the lines.

See:

Calculating and Deleting Subtotals

Deleting Maximum/Minimum

To delete a maximum or minimum, proceed as follows:

- Select one or more columns for which a maximum or minimum was calculated.
- Choose ®
*Maximum*/*Minimum*.

Alternative procedure in full screen mode

In full screen mode, you can also activate the function using the menus.

To calculate a maximum/minimum, proceed as follows:

- Select one or more columns.
- Choose
*Edit*®*Calculate*®*Maximum/Minimum*.

To delete a maximum / minimum, proceed as follows:

- Select one or more columns for which a maximum or minimum was calculated.
- Choose
*Edit*®*Calculate*® Maximum/Minimum.