Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sangland2
Partner - Creator
Partner - Creator

Rounding problem at 4 decimals

Can anyone please explain why

round(223.435 *(1.15) , 0.0001) = 256.9503 (correct answer)

But

round(223.435 *(1+0.15) , 0.0001) = 256.9502

Also with a variable set to 1.15

round(223.435 * (num(vGSTMultipy,0.01)) , 0.0001) = 256.9502

But

round(223.435 * if(vGSTMultipy ='1.15',1.15,vGSTMultipy) , 0.0001) = 256.9503

Labels (1)
1 Reply
swuehl
Champion III
Champion III

Please have a look at

Rounding Errors