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
- 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:
- 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:
- Choose Edit ® Calculate ® Average.
To delete an average, proceed as follows:
- Choose Edit ® Calculate ® Average.
No comments:
Post a Comment