Can you explain a little what the Excel table above means? I assume “Correct Supportable” is what you want. From which columns is it calculated and what is the reset condition?
Yes you right, “Correct supportable” is the outcome i want to archive.
I not sure if cummulative is best option here, but this only solution i could think of.
If(Project OH > 0 => 100% supportable , return to ( MTG RF to Order + Total DC Demand )
If(Project OH < 0 => partial supportable , return to (Project OH M-1) + (MTG RF to Order + Total DC Demand))
In May projected OH is -11676 which mean total supportable only 4964 (from DC OH)
Begining of Jun they received 8145 (from DC Supply) => Jun supportable = 8145.
Reset condition is based on DC Supply. If there is supply will consider Supply intead.
Thank you for helping
Sorry, I still do not get it. In both May and June for Hongkong the Project OH is < 0 (-11676 and -11723), so why treat them differently? In your rules it should both return (Project OH M-1) + (MTG RF to Order + Total DC Demand). What is (Project OH M-1)?
I think my solution using ■■■ toal is cause confusing.
My objective is to calculate project month end stock & how much demand we can support using DC Actual SOH + Total DC Supply - Total DC demand - MTG RF to Order.
I think I understand a bit better now. You need to access previously calculated numbers, right? Could you use the Recursive Loop Start and Recursive Loop End nodes to do the calculation step-by-step?
Lag Column or Column Expression could be used to get the prior rows value. For cumulative computation moving aggregation (one of my favorites) can be used. Maybe you like to have a look at those nodes