Level 2 - Sprint 3 INV 01 - POST AND OFFSET

Star
Regular Contributor

Level 2 - Sprint 3 INV 01 - POST AND OFFSET

Hi

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?

 

Star_2-1589980792349.png

 

 

Star_0-1589980980420.png

 

Thanks.

10 REPLIES 10
smithevan18
Contributor

Hi @Rakesh_24_7 

 

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!