Forum Discussion
Find First Positive AFTER first negative
I'm trying to create an inventory model that shows things we expect to go negative inventory on based on incoming purchase orders vs demand. I've been able to create a way to find the first date we g...
Technically this is easy - compare two adjacent entries and trigger when the prior is negative and the new is positive. But how are you planning to include that in a forecast? Are you estimating the 9/1 date and volume?