calculation and median and mean

[joeybird]

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

[swuehl · Accepted solution]

Maybe you can do it like discussed here:

Average of Delta's

[joeybird]

Hiya

thank you

Kind Regards