Calculation Function - Minus Disposal Month
I need some help in building a model.
So basically, from the above image, I have manage to read the Total Nominate TEUS for each month but I'm not sure How to:
1) let the system to know that, if there's a disposal in a particular month (eg. March and June) then the follow month (Apr and Jul in this example) will use the previous total nominate TEUs - the disposal nominate,
2) and in the subsequent month it will read the latest Total Nominate TEUs.
I have actually created a Boolean in Anaplan, which I think might be needed in the case. (I was trying IF THEN ELSE function but I got stuck)