topic Re: Subtraction float numbers in QlikView https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351590#M616280 <HTML><HEAD></HEAD><BODY><P>For detailed understanding, you may refer: <A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A></P></BODY></HTML> Fri, 04 Aug 2017 09:02:00 GMT tresB 2017-08-04T09:02:00Z Subtraction float numbers https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351588#M616278 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Sorry if this question was recently discussed, I can't find an answer here.</P><P>When I make subtraction of numbers 94.6-94 or 94.4-94 at sheet objects I got unexpected result like 0,59999999999999 or 0,40000000000001.</P><P>Seems that this trouble because of known problem with floating numbers.</P><P>But how it can be solved in QlikView? Only using Round() or set Fixed number at field properties?</P></BODY></HTML> Fri, 04 Aug 2017 08:27:16 GMT https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351588#M616278 Anonymous 2017-08-04T08:27:16Z Re: Subtraction float numbers https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351589#M616279 <HTML><HEAD></HEAD><BODY><P>Qlikview not able to understand the exponential. So that it may shows till there limit(15 digits). So, you have to work on the data points by using Num(). And use Ceil() / Round() / Floor()</P></BODY></HTML> Fri, 04 Aug 2017 08:55:58 GMT https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351589#M616279 Anil_Babu_Samineni 2017-08-04T08:55:58Z Re: Subtraction float numbers https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351590#M616280 <HTML><HEAD></HEAD><BODY><P>For detailed understanding, you may refer: <A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A></P></BODY></HTML> Fri, 04 Aug 2017 09:02:00 GMT https://community.qlik.com/t5/QlikView/Subtraction-float-numbers/m-p/1351590#M616280 tresB 2017-08-04T09:02:00Z