Formula for calculating Time Coverage
Hi everyone! I'm having trouble in resolving these request in Anaplan. Basically I've got 2 line items in a module with Time Scale Weeks:
- Expected Sales Quantity = Qty of Product that is expected to sell in every week
- Final Stock Quantity = Qty of Product in Stock in every week
The request is to calculate for each week of the module, how many weeks that specific
quantity of Final Stock Quantity covers the Expected Sales Quantity (as the sum from the week of the final stock quantity onwards.)
Below an example:
I am not finding any formula within Anapedia that can solve the case.
Thank you so much for your help!