0 Replies Latest reply: Apr 18, 2017 6:01 AM by Gauthier vande Moortele RSS

    Rounding issues in Qlik Sense

    Gauthier vande Moortele

      Hello All,

       

      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 ?

       

      Regards,

       

      Gauthier