Hello
can you help me in perfecting my formula ?
- Reorder Flag: Identifies the week that an order must be placed before the ending inventory would drop below 0.
As you see in the week 11 FY20 column, the reorder flag is not ticked even though the value is negative
My doubt is, as per the hint, they suggested the use of the OFFSET formula, and as per logic, when the ending inventory value for the future week is less than zero based on the shipping time week for the product SKU , then reorder flag should be raised
so I have written this formula OFFSET(Ending Inventory, -Shipping Time Weeks, 0) < 0,
As per my understanding, the current week ending inventory value will be copied to the concerned future week value based on the shipping time weeks and then it comapres the value is zero or not ? AM I right?
but how to check the value on the future ending inventory value is less than zero by using shipping time weeks using offset function? (because offset function just copies the values to the destined cell )
