This content has been marked as final. Show 2 replies
i have this calculation
=Alt(Sum(Orders) - Above(Sum(Orders)), 0)
this gives me the difference in number for each week orders.
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)