hi Qlik community,
I've tried to understand the function, Round(). I guess it might be a bug but before reporting the case, I would like to try here first, maybe, you can give me a good explanation. The values with Bold, Italic, and Underlined font are the ones, I can't understand and I doubt, if they are arithmetically correct?
| NineFive | Round(NineFive, 0.1) | Round(NineFive, 0.1, 1) |
| 0.95 | 0.9 | 1.0 |
| 1.95 | 2.0 | 2.0 |
| 2.95 | 3.0 | 3.0 |
| 3.95 | 4.0 | 4.0 |
| 4.95 | 5.0 | 5.0 |
| 5.95 | 6.0 | 6.0 |
| 6.95 | 7.0 | 7.0 |
| 7.95 | 8.0 | 8.0 |
| 8.95 | 8.9 | 8.9 |
| 9.95 | 9.9 | 9.9 |
| 10.95 | 10.9 | 10.9 |
| 17.95 | 17.9 | 17.9 |
| 28.95 | 29.0 | 28.9 |
| 39.95 | 40.0 | 40.0 |
| 43.95 | 44.0 | 44.0 |
| 53.95 | 54.0 | 54.0 |
| 77.95 | 78.0 | 78.0 |
| 81.95 | 82.0 | 82.0 |
| 87.95 | 88.0 | 88.0 |
| 89.95 | 90.0 | 90.0 |
| 98.95 | 99.0 | 99.0 |
| 100.95 | 101.0 | 101.0 |
| 101.95 | 102.0 | 102.0 |
| 102.95 | 103.0 | 103.0 |
| 103.95 | 104.0 | 104.0 |
| 104.95 | 105.0 | 105.0 |
| 105.95 | 106.0 | 106.0 |
| 106.95 | 107.0 | 107.0 |
| 107.95 | 108.0 | 108.0 |
| 108.95 | 109.0 | 109.0 |
| 109.95 | 110.0 | 110.0 |
| 119.95 | 120.0 | 120.0 |
| 357.95 | 357.9 | 357.9 |
Any comment is appreciated 🙂
Thank you 🙂
kanhomcake
