Calculate Results As...
You use this function to recalculate results rows displayed in the BEx application according to specific criteria. These local calculations include only those numbers in the calculation that appear in the current view of the BEx application. You thus override the standard calculations in analytic manager.
You can use this function in the following areas:
| Tool/Application | Details |
|---|---|
BEx Query Designer |
For structure elements in the selection or formula properties More information: Selection/Formula/Cell Properties |
BEx Web Applications |
More information: Context Menu Functions Properties of Structure Elements and Data Cells |
BEx Analyzer |
In the key figure properties More information:Key Figure Properties |
The Calculate Results As function is not supported for active display hierarchies.
Note that the local calculations only change the display of the values. With subsequent calculations, the system does not use this value changed for the display, but rather the original value specified by the analytic manager.
More information: Interpretation of Results Rows
Note that the features outlined below are available in Web applications only; the BEx Query Designer and the BEx Analyzer supports only some of these functions.
You can choose from the following settings:
| Settings | Description |
|---|---|
(Nothing Defined) |
This setting displays the results provided by the analytic manager. No local calculation takes place. |
Minimum |
The smallest value for the corresponding area is displayed as the result. |
Maximum |
The largest value for the corresponding area is displayed as the result. |
Total |
The sum total of the values for 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 sum of rounded values locally since the total sums can differ considerably (in particular with high scaling factors). Note
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 single values affected are taken into account (without results). |
Counter for all detailed values |
The number of values for the corresponding area is displayed as the result. |
Counter for All Detailed Values That Are Not Zero, Null, or Error |
The number of values for the corresponding area, excluding zeros, is displayed as the result; values equal to zero are not included. |
First Value |
The highest value or the value furthest to the left of the corresponding area is displayed as the result. |
First Value That Is Not Zero, Null, or Error |
The highest value or the value furthest to the left that is not equal to zero 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. |
Last Value That Is Not Zero, Null, or Error |
The lowest value or the value furthest to the right that is not equal to zero is displayed as the result. |
Average |
The average (total divided by total number of values) of all values for the corresponding area is displayed as the result. |
Average of Detailed Values That Are Not Zero, Null, or Error |
The average (total divided by number) of all values for the corresponding area is displayed as the result, with the exception of zeros, meaning that values equal to zero are not counted. |
Standard Deviation |
Statistical deviation is a measure of the distribution of the values with respect to the mean value (average). Statistical deviation = root from the variance: SQRT (variance) |
Median |
The system sorts the values internally by size and displays the mean value from the list as the result. For example, if there are five values in the list, the third value is displayed as the result. If the list has an even number of values (for example, six), the system adds the two values in the middle of the list together - in this case, the third and fourth values - and divides the result by two. The resulting value is displayed as the result. |
Median of Detailed Values That Are Not Zero, Null, or Error |
Excluding the values that are equal to zero, the system sorts the values internally by size and displays the mean value from the list as the result. For example, if there are five values in the list, the third value is displayed as the result. If the list has an even number of values (for example, six), the system adds the two values in the middle of the list together - in this case, the third and fourth values - and divides the result by two. The resulting value is displayed as the result. |
Variance |
The following formula is used to calculate the statistical variance: ( x² - ( x)² / N) / (N-1) for N > 1 and notexist for N=1 |
Hide |
The result is not displayed. |
Summation of Rounded Values
The following example shows the values of a simple query in which sales have been set with a scaling factor of 1,000:
| Customer | Sales |
|---|---|
| EUR 1,000 | |
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 |
|---|---|
| EUR 1,000 | |
Customer 1 |
2,25 |
Customer 2 |
2,13 |
Total |
4,37 |
You can see that the total displayed locally is not the value that you would expect. This value was calculated by first making the calculation and the displaying and rounding the values.
If you activate the function Summation of Rounded Values, the values are rounded first, then calculated, and then displayed. The query then appears as follows:
| Customer | Sales |
|---|---|
| EUR 1,000 | |
Customer 1 |
2,25 |
Customer 2 |
2,13 |
Total |
4,38 |