Hi
I'm trying to calc average stocks both monthly and *** to date for a variety of departments
Stock build differently across departments so I need a calc that is flexible
Currently on enclosed the average stock calc used for YTD is distorted by the much lower numbers in previous minths
Is it possible to assign an average calc with a " threshold"

thanks
PeterAverage Threshold.xls