Calculate Result As... 
Use
You use this function to recalculate the results rows displayed in the report according to particular criteria. These local calculations include only those numbers in the calculation that appear in the current view of the report. In this way, you override the standard OLAP processor calculations.
You can use this function in the following areas:
Query Designer: In structural components in the dialog box Selection/Formula Properties
Web Applications: In the context menu for structural components (see Context Menu Functions)
BEx Analyzer: In dialog Key Figure Properties
The Calculate Results As… function is not possible when there are active presentation hierarchies.
Note that the local calculations only change the display of the values. With subsequent calculations, the system does not use this for the display of the changed value, but rather the original value specified by the OLAP processor. For more information, see Interpretation of Results Rows.
Features
You can choose from the following functions:
· (Nothing Defined)
· Summation
The sum total of the values for the corresponding area is displayed as the result.
· Maximum
The maximum (largest) value of the corresponding area is displayed as the result.
· Minimum
The minimum (smallest) values for the corresponding area is displayed as the result.
· Count all values
The number of values for the corresponding area is displayed as the result.
· Count All Values <> 0
The number of values for the corresponding area is displayed as the result, with the exception of zeroes, meaning that values equal to 0 are not counted.
· Average of all values
The average (total divided by total number of values) of all the values for the corresponding area is displayed as the result.
· Average of all values <> 0
The average (total divided by number) of all values for the corresponding area is displayed as the result, with the exception of zeroes, meaning that values equal to 0 are not counted.
· Standard deviation
The standard deviation is a measure used to show how the values are spread in relation to the mean value (average). Standard deviation = Root from the variance: SQRT (variance)
· Variance
The following formula is used to calculate the variance:
(å x² - (å x)² / N) / (N-1) for N > 1 and notexist for N=1
· Suppress result
The result is not displayed.
· First value
The highest value or the value furthest to the left of the corresponding area is displayed as the result.
· Last value
The lowest value or the value furthest to the right of the corresponding area is displayed as the result.
· Summation of rounded values
If you have set a scaling factor, it is useful to calculate the total of rounded values locally since the totals (in particular with high scaling factors) can differ considerably.
If the result is a totals row, the area calculated is the corresponding column.
If the result is a totals column, the area calculated is the corresponding row.
With higher totals, that is multiple drilldowns (with results and an overall result), all of the single values affected are taken into account (without results).
The following example shows the values of a simple query where sales has been set with a scaling factor of 1,000.
Customer |
Sales |
|
1,000 EUR |
Customer 1 |
2,246 |
Customer 2 |
2,126 |
Total |
4,372 |
If you now reduce the number of decimal places, the values are rounded:
Customer |
Sales |
|
1,000 EUR |
Customer 1 |
2,25 |
Customer 2 |
2,13 |
Total |
4,37 |
You can see that the total seen locally is not the value that you would expect. This value was calculated first then displayed and then the value was rounded.
If you activate the function Summation of Rounded Values, the value is rounded first, then calculated, then displayed. The query then appears as follows:
Customer |
Sales |
|
1,000 EUR |
Customer 1 |
2,25 |
Customer 2 |
2,13 |
Total |
4,38 |