topic Issue with Round Function for #,##0.95 Values in App Development

Issue with Round Function for #,##0.95 Values

kanhomcake — Thu, 29 Apr 2021 12:38:03 GMT

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

Re: Issue with Round Function for #,##0.95 Values

Digvijay_Singh — Thu, 29 Apr 2021 16:45:24 GMT

Can you show 3 decimal points in the 'NineFive' field? Just want to check if .95 is something like .949 actally.

Re: Issue with Round Function for #,##0.95 Values

kanhomcake — Fri, 30 Apr 2021 05:54:27 GMT

hi @Digvijay_Singh ,

The original values are exactly as you see in the first column, I load inline, forcing every value ends only with 2 digits, .95, there is no third digit in the original value.

kanhomcake

Re: Issue with Round Function for #,##0.95 Values

MayilVahanan — Fri, 30 Apr 2021 06:02:14 GMT

HI @kanhomcake

Try like below

=Round(357.95 + 0.000000001, 0.1, 1)

https://whatis.techtarget.com/definition/rounding-error

Re: Issue with Round Function for #,##0.95 Values

tresB — Fri, 30 Apr 2021 08:01:12 GMT

I am not going much into detail of your post and investigate, because it is a know fact and NOT error in qlik. Please read this post:

https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

Re: Issue with Round Function for #,##0.95 Values

kanhomcake — Fri, 30 Apr 2021 07:54:56 GMT

@tresB thanks for the link, good explanation there. Luckily, we all IT nerds can understand it. Now, I have to explain this to business users/self-service users. It could be a challenge, especially, when MS Excel manages to make it arithmetically correct as what we've all learnt in school 😉