Hi @Melissa,
I’m hoping you could help me out also. I currently have a Projected SOH calculation that is working fine using the method you suugested in this post:
However as mentioned above, I have been tasked with modifying it so that it doesn’t go into negative, i.e. whenever the projection is less than or equal to zero it stays at zero, then continues to accumulate from the next positive movement (Purchase Order received).
You will see from my last post where I currently have it. It is partially correct in that it worked after the first positive entry but as the calculation is based on the original accumulation it falls apart very quickly.
I essentially need to work out how to reset the count when it goes below zero. I’m hoping you can help steer me in the right direction.
If the information here is not enough, I’ll try and put together another sample file and post that in a couple days.
Thanks in advance.
Mark D