I load data from a table having a column with datatype decimal(17,2); it's dedicated to financial amounts.
When Qlik sense displays a (large!) sum on this column, the result differs slightly from the result I get with a SQL-query. More surprisingly, Qlik sense gives different results in the sum of a table and in a text field with the formula Sum([MU Amount]):
The correct result is:
The difference is only some units on a large amount, but it's unacceptable with financial data.
As a workaround, I use a new column where these values are multiplied by 100 and casted to integer, I perform a sum on it and I divide the result by 100 ( Sum([MU Amount x 100])/100 ). And I don't use the total in tables anymore.
Does anybody encounters the same type of issue ?