Taking average of data in two months

[#1]

hi all,

I would like to calculate the (open bal+ ending bal)/2 which is the data in for example, average of Jun balance and July balance

and the data should be show on the row of July

for example:

Month	Open_Amt	average
04	100
05	200	(100+200)/2=150
06	250	225
07	300	275

However, I cannot manage to write expression to represent the average value of two row

Can anyone teach me what should i do to show average?

Thanks,

K

[#2]

(above(expression,0,1)+ expression)/2

or

rangeavg (above(expression,0,2))

[#3]

Thanks , I have tried using this expression as well. But there's another problem is that the first month data cannot be displayed( e.g. for 2012 Jan, I would like to have an average value with 2011 Dec). Moreover, when there is filtering in months that is not in sequences (for example, 01,04,05) the data shown would be wrong.

So I am wondering how I could solve this problem.

Thanks

[#4]

can you post a sample file?

[#5]

As shown in the file, the first data of 2012 cant be display.