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

    Total does not add up

    Nayan Lalla

      Hi

       

      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

      Nayan