k_v_deepu
08-27-2008, 06:56 AM
Hi Everybody
I have calculate average of 6 months, my columns are as below
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
150 130 100 120 125 130 140 135
in my function i should select all the 12 columns but it should calculate
the average of the last 6 months only. In the above example it should
give the average of Mar - Aug
can anyone help how to go about for this
Thanks
Deepak
I have calculate average of 6 months, my columns are as below
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
150 130 100 120 125 130 140 135
in my function i should select all the 12 columns but it should calculate
the average of the last 6 months only. In the above example it should
give the average of Mar - Aug
can anyone help how to go about for this
Thanks
Deepak