Level 2 Sprint 3 INV01 Confirmed PO Delivery
So I'm having some issues (or more likely a misunderstanding) with my formula for Confirmed PO Delivery.
I'm still at the OFFSET stage & haven't yet got to the POST conversion that I think comes later based on other forum posts.
I'm trying to use:
Confirmed PO Delivery = IF OFFSET(PO Submitted, -Final Shipping Time Weeks, 0) = 0 THEN 0 ELSE 1
In my head this works by saying if x weeks ago I submitted a PO then I should receive it now. This worked fine when just using the default shipping times because they were always the same.
Now that I am trying to use the Override if I submit a PO in Week 1 and change it to Air (1 week shipping) my formula for checking receipt in Week 2 is OFFSETTING based on the 2 weeks default for Road shipping from Week 2
Here is what I'm getting for Confirmed PO Delivery (0, 0, 1, 1) which I know how it is derived, but I don't know how to get this to be (0, 1, 0, 1) using the 1 week shipping in week 1, and 2 week shipping in Week 2 - it's almost like I need the OFFSET to be recursive