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