9 Replies Latest reply: Mar 19, 2014 11:27 AM by Keith Reid RSS

    Double Counting in Straight Table Formulae

    Keith Reid

      I have created a straight table and a cumulative total column using the following formula:


      =RangeSum (Above(TOTAL(([Units])),0,NoOfRows(TOTAL)))


      I have then tried to create a series of columns that do the same thing for individual stock items:




      My problem is that the individual stock columns are subject to random double counting of some individual transactions.


      Can anybody see why?