Start of Content Area

Procedure documentation Making Calculations  Locate the document in its SAP Library structure

Use

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.

Procedure

...

       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.

Result

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.

 

End of Content Area