Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Thanks for all your support for previous responses.
I am trying to find cumulative Net Stock value using the below formula.
Formula | Delivered+(Closing-Opening) |
Delivered | Sum(Delivered for the whole year) |
Closing | sum(Closing for the whole year) |
Opening | It will remain constant for all months i.e. March'17 value |
In the calculation, my opening stock balance will remain constant for all the month. Lets Assume, I am in the month of January'18 & want to see the data YTD December'17. Here;
Delivered = 99(cumulative value)
Closing = 606
Opening = 100
Net Stock = Delivered + (Closing - Opening)
hence Net Stock = 99+(606-100)
Therefore Net Stock = 605.
Similar to above example, I want to apply the same approach to each month.
Attached is the sample with formula & output looking at.
Kindly assist with the same.
Hi,
would you be able to describe the expected output ?
Expected output is already there in the attached excel.
Something like this ?
!
The output must be as mentioned below;
Month | Apr'17 | May'17 | Jun'17 | Jul'17 | Aug'17 | Sep'17 | Aug'17 | Sep'17 | Oct'17 | Nov'17 | Dec'17 |
Toy | 50 | 101 | 153 | 206 | 260 | 315 | 371 | 428 | 486 | 545 | 605 |
Like this?