Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

1 Reply
swuehl
MVP
MVP

Please have a look at

Rounding Errors