7 Replies Latest reply: Oct 28, 2015 8:59 AM by Joanna Seldon RSS

    calculation - range sum

    Joanna Seldon

      Hiya

       

      I want to show difference for each department - per week

       

      I have this calculation

       

      rangesum( above( sum(ORDERS),0,rowno()))

       

      its adding up the rows...I wish to show difference

       

      e.g

       

      week 1 = 30

       

      week 2 = 35

       

      difference is 5

       

      Please help