4 Replies Latest reply: Sep 7, 2018 6:51 AM by kaan erisen RSS

    getting error in calculating sum(EBITDA) in qliksense

    Divyanshi Bansal

      Hi All,

       

      test.PNG

      I am calculating sum(EBITDA) for one customer A .

      I have Target Revenue column which is 1st column and then the Target EBITDA% which is in 2nd column.

      At backend, I convert sum(Target EBITDA%)/100 as Target EBITDA%

      Now I calculate 3rd column which sum(Target Revenue) * sum(Target EBITDA%)

       

      Now in the above table sum is coming out to be 5.99 but this is not the total of all individuals rows which has 1.00.

       

      How I get the correct sum?

       

      Kindly help.