Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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