topic Re: Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that? in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Importing-from-SQLServer-I-divide-amount-with-1000000-This/m-p/1236548#M6574 <HTML><HEAD></HEAD><BODY><P>Probably because of rounding errors: <A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A>.</P></BODY></HTML> Mon, 28 Nov 2016 13:24:14 GMT Gysbert_Wassenaar 2016-11-28T13:24:14Z Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that? https://community.qlik.com/t5/Integration-Extension-APIs/Importing-from-SQLServer-I-divide-amount-with-1000000-This/m-p/1236547#M6573 <HTML><HEAD></HEAD><BODY><P>Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that?</P><P></P><P>If I import amount as they are everything is OK.</P><P></P><P>I present the result in QLIK Sense desktop&nbsp; formatting as Number&nbsp; and Simple.</P><P>The result in&nbsp;&nbsp; SQL is&nbsp; 13261,0996&nbsp;&nbsp;&nbsp; and in QLIK Sense&nbsp;&nbsp;&nbsp;&nbsp; 13 260,70 </P><P></P><P>When I divide using expressions the result is correct so I should probably do it like this instead.</P><P></P><P></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp; Leif</P></BODY></HTML> Mon, 28 Nov 2016 12:55:08 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Importing-from-SQLServer-I-divide-amount-with-1000000-This/m-p/1236547#M6573 2016-11-28T12:55:08Z Re: Importing from SQLServer I divide amount with 1000000. This produces a different result than when I do the same operation in SQLServer. Why is that? https://community.qlik.com/t5/Integration-Extension-APIs/Importing-from-SQLServer-I-divide-amount-with-1000000-This/m-p/1236548#M6574 <HTML><HEAD></HEAD><BODY><P>Probably because of rounding errors: <A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A>.</P></BODY></HTML> Mon, 28 Nov 2016 13:24:14 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Importing-from-SQLServer-I-divide-amount-with-1000000-This/m-p/1236548#M6574 Gysbert_Wassenaar 2016-11-28T13:24:14Z