1 Reply Latest reply: Nov 28, 2016 8:26 AM by Gysbert Wassenaar RSS

    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?

    Leif Nicholaisen

      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?

       

      If I import amount as they are everything is OK.

       

      I present the result in QLIK Sense desktop  formatting as Number  and Simple.

      The result in   SQL is  13261,0996    and in QLIK Sense     13 260,70

       

      When I divide using expressions the result is correct so I should probably do it like this instead.

       

       

       

       

      Best Regards,   Leif