Show TOC

Example: Calculate Results AsLocate this document in the navigation structure

The following example serves to illustrate the significance of the Summation of Rounded Values function. The first table 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 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 use the Summation of Rounded Values function, the values are first rounded and then calculated and displayed. The query then appears as follows:

Customer Sales
EUR 1,000

Customer 1

2.25

Customer 2

2.13

Total

4.38