5 Replies Latest reply: Oct 15, 2013 7:42 AM by Nayan Lalla RSS

    Total does not add up



      I have a problem with a pivot table where the total do not add up.

      I have a buying template and want to calculate the stock required which is  (if negative , give zero):



      if(Average*7-[Stock on Hand]+[Sales Order]<0,0,Average*7-[Stock on Hand]+[Sales Order]) .


      The only problem im having is that total of the "stock required"  is incorrect.  The total should be 10,697 and not 9768.


      im aware that the solution works for a straight table.  I want it to work for a pivot table.


      I have attached the Qlikview Model as well as the data (in excel)


      Please can you help.


      kind regards