3 Replies Latest reply: Sep 12, 2012 3:22 AM by Jason Michaelides

# cumulative balance issue..

 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

• ###### Re: cumulative balance issue..

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..

• ###### Re: cumulative balance issue..

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

• ###### Re: cumulative balance issue..

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