4 Replies Latest reply: Aug 13, 2017 2:25 PM by Wendy Harrison RSS

    How do I round all calculations to 2 decimal places

    Wendy Harrison

      Hi,

       

      Please could someone help as I have tried everything I can think of.

       

      I am working in Qlik Sense with lots of data.

       

      Unfortunately Qlik Sense is calculating my results by several decimal places and this is having a knock on effect to my overall calculations.

       

      For example one of my calculations is 21.74 * 10.94 which should equal 237.84

       

      Qlik Sense is calculating it as 21.7434736842105 * 10.94 giving me a result of 237.87

       

      Please could someone advise how I get Qlik Sense to do all my calculations at 2 decimal spaces.

       

      Many Thanks

      Kind Regards

      Wendy