Level 2 - Sprint 3 INV 01 - POST AND OFFSET
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?