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

Options
satyampatil
satyampatil Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & 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:

Categories