Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

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
MVP
MVP

Re: Rounding problem at 4 decimals

Please have a look at

Rounding Errors