Calculate Results As
Calculate Result As allows you to select which rule to use to locally recalculate the results of a report.
Note that the functions listed below are not fully supported by all clients.
You can choose from the following settings:
| Settings | Description |
|---|---|
(Not defined) |
This setting displays the results provided by the analytic manager. No local calculation takes place. |
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 zeroes, meaning that values equal to zero are not counted. |
Counter of All Detailed Values |
The number of values for the corresponding area is displayed as the result. |
Counter of All Detailed Values That are Not Zero, Null or Error |
The number of values for the corresponding area, excluding zeroes, 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. |
Hide |
The result is not displayed. |
Last Value |
The lowest value or the value furthest to the right of the corresponding area is displayed as the result. |
Maximum |
The largest value for the corresponding area is displayed as the result. |
Minimum |
The smallest value for the corresponding area is displayed as the result. |
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). |
Summation |
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, multiple drilldowns (with results and an overall result) that is, all single values affected are taken into account (without results). |
Variance |
The following formula is used to calculate the statistical variance: (å x² - (å x)² / N) / (N-1) for N > 1 and notexist for N=1 |