cumulative balance issue..

[sudeep_d]

APRIL					MAY
Opening Stock	V1	v2	V3	Balance	Opening Stock	V1	V2	V3	Balance
0	10	5	3	2	2	8	2	2	6

Here The opening stock in the 1st month is 0 and in the second month (i.e may) is the value of balance in previous month(i.e april) and balance is calculate by formula column(1)+column(2)-column(3)-column(4),

      where column(1)= opening stock

                     coluimn(2) =V1

                     column(3)=V2

                       column(4) = V3

What should be the expression for the Opening stock(i . e column(1))??

Note: If i select May, the value of opening stock still should remain 2 ,not 0

Any help would be appreciated

Thanks

Sudeep

[#2]

Use peek Or Previous .. to get the Balance of Previous month and put the same in the Next Month Opening Stock.

Also let me know wether the same has to be done at back end or front end..

[sudeep_d]

Hi Rishi,

Peek and Previous are back end fuctions but i have to calculated it in the front end.

In the above example th e five different columns are 5 diff expressions where v1 v2 v3 are showing count of machines

Thanks

[Jason_Michaelides]

I think you'll need a combination of Aggr() and RangeSum() and Above(). Please post your app to make it easier to help you.

Jason