Line Items Related to Purchase Orders : Confirmed PO Delivery (Level 2 Sprint 3)

satyampatil
satyampatil
in Modeling
  • Set the Confirmed PO Delivery line item to use the PO Submitted 1 value and OFFSET it based on the number of weeks between the order and delivery.

    For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed PO Delivery line item in Week 3.

According to the question I'm trying to generate the formula and what i think is if the shipping time week has value 2 then after 2 week PO submitted will get value 1.

So, according to my logic the formula should look like this "OFFSET(PO Submitted, -2, 0)"

and the actual formula should look like this "OFFSET(PO Submitted, -Shipping Time Weeks , 0)"

 

-ve sign because we want PO submitted after 2 week and 0 because we want other value to stay 0.

 

Is my logic correct? If my formula is wrong please help me to correct that

 

Thankyou ! 🙂

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @satyampatil 

    You're super close and your logic is spot on. However, there is a more efficient function you can use rather than using OFFSET. It's a bit of a trick question but the function they want you to study is the POST function. Take a look at that and see if you change your mind a bit.

    Correct Answer is: Confirmed PO Delivery = POST(PO Submitted, Final Shipping Time Weeks)

Categories