Rounding handling in EPCM
Hello everyone! We have a situation that the EPCM calculating the result which is different from the using Excel for allocation. We believe it is because of the EPCM rounding handling. What is the rounding handling in EPCM? We set the decimal places as 2. The situation is:
Source | 71904.65 | |||||
---|---|---|---|---|---|---|
Driver | 0.29 | 0.25 | 0.15 | 0.13 | 0.03 | 0.15 |
EPCM result | 20852.33 | 17976.16 | 10785.71 | 9347.61 | 2157.13 | 10785.71 |
Excel result | 20852.3485 | 17976.1625 | 10785.6975 | 9347.6045 | 2157.1395 | 10785.6975 |
Variance | -0.0185 | -0.0025 | 0.0125 | 0.0055 | -0.0095 | 0.0125 |
We would like to know how the EPCM handle the rounding in this situation.
Thanks
Gary
0