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?

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

Probably because of rounding errors: Rounding Errors.