Hello All,
I'm sure this is gonna be obvious but here we go...
I have a table that will have different products, different sites and show's the balance for each week.. What I want to show, is how many weeks they have until the balance is 0 (or less).
In the load script, I take the daily balance and then subtract the forecasted qty for each week, but I want to show to the users A) How many weeks they have left and B) what week will the stock run out.
I've attached a screenshot to show an example of product.. Could you advise as to how to achieve this? (I'm thinking an aggr for Prod, Site, but not sure!)
Many thanks!!
Dayna
