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 |