Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
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
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