topic Rounding problem at 4 decimals in QlikView https://community.qlik.com/t5/QlikView/Rounding-problem-at-4-decimals/m-p/1003185#M959814 <HTML><HEAD></HEAD><BODY><P>Can anyone please explain why </P><P>round(223.435 *(1.15) , 0.0001) = 256.9503 (correct answer)</P><P>But</P><P>round(223.435 *(1+0.15) , 0.0001) = 256.9502</P><P></P><P>Also with a variable set to 1.15 </P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">round(223.435 * (num(vGSTMultipy,0.01)) , 0.0001)</SPAN> = 256.9502</SPAN></P><P><SPAN style="font-size: 13.3333px;">But<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">round(223.435 * if(vGSTMultipy ='1.15',1.15,vGSTMultipy) , 0.0001) </SPAN>= 256.9503</P></BODY></HTML> Sun, 01 Nov 2015 09:01:33 GMT sangland2 2015-11-01T09:01:33Z Rounding problem at 4 decimals https://community.qlik.com/t5/QlikView/Rounding-problem-at-4-decimals/m-p/1003185#M959814 <HTML><HEAD></HEAD><BODY><P>Can anyone please explain why </P><P>round(223.435 *(1.15) , 0.0001) = 256.9503 (correct answer)</P><P>But</P><P>round(223.435 *(1+0.15) , 0.0001) = 256.9502</P><P></P><P>Also with a variable set to 1.15 </P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">round(223.435 * (num(vGSTMultipy,0.01)) , 0.0001)</SPAN> = 256.9502</SPAN></P><P><SPAN style="font-size: 13.3333px;">But<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">round(223.435 * if(vGSTMultipy ='1.15',1.15,vGSTMultipy) , 0.0001) </SPAN>= 256.9503</P></BODY></HTML> Sun, 01 Nov 2015 09:01:33 GMT https://community.qlik.com/t5/QlikView/Rounding-problem-at-4-decimals/m-p/1003185#M959814 sangland2 2015-11-01T09:01:33Z Re: Rounding problem at 4 decimals https://community.qlik.com/t5/QlikView/Rounding-problem-at-4-decimals/m-p/1003186#M959815 <HTML><HEAD></HEAD><BODY><P>Please have a look at</P><P><A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A></P></BODY></HTML> Sun, 01 Nov 2015 17:48:26 GMT https://community.qlik.com/t5/QlikView/Rounding-problem-at-4-decimals/m-p/1003186#M959815 swuehl 2015-11-01T17:48:26Z