Expression?

[khadeer]

Hi i am again with same,

I have opning balance for every month, it will carry forwarded to next month,

Suppose in the month Apr i have my opning as 5000(i.e March closing in previous year)

every month we have value,

Apr = 300, May=-100, June=200, July= 300, Aug=-100, Sep=100

My result should be like this, if i selected Apr .... Closing of previous month+ value of present mnth....

i.e  5000+300= 5300 i am getting this value

now for May 5300-100= 5200, like this June= 5200+200= 5400, July 5400+300= 5700, Aug=5700-100= 5600, Sep 5600+100= 5700 this also i am getting correct.

But my issue is , If i selected Apr, May , June ... I need Apr(opening)+June(Closing)= 5000+5400, it should change dynamically as per selections. I need it in expression.

Please help on this.