Hi,
I am trying to calculate the ageing for my certain stock.
In my business scenario, there is a daily report to show what are the stocks need to take actions, and the requirement is to track the ageing for that stock.
For example, on the 7/17, I have one stock A, so I clear it and it will not show in the 7/19 report, so the age of stock A will be 1. While, on 7/19, I have another new stock B need to be cleared, but I forgot to take action, and it shows on 7/22 report, so the age is 2 days. The sample data shows in the screenshot, and I have manually created the expected results "Age" column.
Anyone can advise how can I get the expected results?
Thanks.
------------------------------
Zhang Haoran
------------------------------