1) I am trying to get some sense on POST and OFFSET with the following 2 line items:
a) Confirmed PO Delivery = OFFSET(PO Submitted, Final Shipping Time Weeks, 0)
b) Confirmed PO Delivery Test = POST(PO Submitted, Final Shipping Time Weeks)
and appreciate explanations on it.
2) If testing above, for Confirmed PO Delivery, if I switch to -Final Shipping Time Weeks, it did not push to Week 6 (2nd diagram). Why is that so?
Go to Solution.
You shouldn't need the conditional portion of that formula because the PO submitted line item is already taking into account whether or not you've submitted a PO. You are only trying to move the value in PO Submitted by your shipping time in weeks.
Hope that helps!