Week Coverage, also known as forward coverage or stock cover

A description of the enhancement requested
Week Coverage, also known as forward coverage or stock cover.
As an example we have Forecast Sales and Current Stock.
Formula should calculate how many future periods of forecast will be covered by Current stock.
This is achievable in Anaplan with below function:
Look Forward + (Stock - MOVINGSUM(Forecast Sales, 1, Look Forward, SUM)) / OFFSET(Forecast Sales, Look Forward + 1, 0)
"Look Forward" is a list item of number format where you give the number of value to look forward.
The formula is complicated, and MOVINGSUM only accepts time dimension.
A story for why they want the enhancement (specifically how would it help their business process)
I am pretty sure every supply planning models require this calculation. It is very informative for planners.
Users wanting similar expression can be found in below links.
https://www.excelbanter.com/excel-worksheet-functions/64914-help-single-cell-formula-calculate-weeks...
https://www.mrexcel.com/forum/excel-questions/415158-inventory-forward-cover-calculation.html
This formula can be used for other financial calculations as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.