View Single Post
  #2   Report Post  
Old October 29th 04, 11:48 AM
Frank Kabel
 
Posts: n/a
Default

Hi
and how do you want to define your trend?

"Vinaya" wrote:

Hi,

I need to calculate average of 3 months. However, if any particular
month is defying the normal trend, that month should be ignored while
calculating the average.

For Eg:

Jan Feb Mar Average
2 2 2 2
4 4 6 4
2 1 2 2


Is this possible?

Regards,
Vinaya.