8 Replies Latest reply: Nov 11, 2014 4:37 AM by Nayan Lalla RSS

    Sub-Totals in Straight Table not adding up

    Nayan Lalla

      Hi

       

      I have a straight table with sub-totals , however the sub-totals do not add up.

      Attached herewith is an extract of my buying template which i exported to excel.   The only column where the totals dont add up is the stock required column. 

       

      The formula for stock required is a follows:

      if(Average Last 6 Months * No of Months - Stock on Hand < 0 ,0 , Average Last 6 Months * No of Months - Stock on Hand)

       

      In the expression tab , I have changed the "Total Mode" to Sum, however its still recognising it as a "Expression Total".

      Also the Grand Total for this expression is also incorrect.

       

      I even changed the chart to pivot table and it still shows incorrect result.

       

      Please can you help.  Do i need to change my formula for stock required.

       

      kind regards

      Nayan