2 Replies Latest reply: Oct 30, 2015 7:00 AM by Joanna Seldon RSS

    calculation and median and mean

    Joanna Seldon

      Hiya

       

      i have this calculation

       

      =Alt(Sum(Orders) - Above(Sum(Orders)), 0)


      this gives me the difference in number for each week orders.


      e.g


      week 1  = 0,


      week 2 = 15


      week 3 = 5


      i then want to add a sum to this to work out the mean and median of these figures.


      e.g using additionally .... mean(Orders)


      please help