4 Replies Latest reply: Dec 15, 2017 7:32 AM by Sunny Talwar RSS

    Wrong Table Total

    zahid Rahim

      Dear Experts,

       

      I have a column in table with some calculation. It is showing correct individual values but the total is wrong. I export the data in excel and the total in excel and qlik have huge difference.

       

      Formula used is:

       

      ((SUM(FABS(INPUT_QUANTITY))-SUM(OUTPUT_QUANTITY))/SUM(FABS(INPUT_QUANTITY)))*100

       

      Regards,

       

      Zahid Rahim