Calculating and Deleting Averages

Prerequisites

You can calculate averages for several columns. (note: only applies to Key Figures).

If the average is calculated using heterogeneous units, such as kilograms and liters or several currencies, an average is calculated for each unit.

Procedure

Calculating average

  1. Select one or more columns.
  2. Choose ® Average.

Result

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

Depending on the list, the average may be displayed above the lines.

See:

Calculating and Deleting Subtotals

Deleting Averages

To delete an average, proceed as follows:

  1. Select one or more columns.
  2. Choose ® Average.

Alternative procedure in full screen mode

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

To calculate an average, proceed as follows:

  1. Select one or more columns.
  2. Choose Edit ® Calculate ® Average.

To delete an average, proceed as follows:

  1. Select one or more columns for which an average was calculated.
  1. Choose Edit ® Calculate ® Average.