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:

       

      =Rangesum(Above(TOTAL(sum({$<[Code]={"CPG"}>}[Units])),0,NoOfRows(TOTAL)))

       

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

       

      Can anybody see why?

       

      Keith