INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

Hi,

 

I enjoyed L2 Model building, but I am stuck with Confirmed Purchase Order Receipt formula in INV01. Can you please check my formula and suggest what I am missing?

 

Correct results are showing when I used below formula but not working in exam

IF Confirmed PO Delivery > 0 THEN POST(Suggested Order Amount for the Month, Final Shipping Time Weeks) ELSE 0

 

I also tried below formulas in exam, but it did not work.

IF Confirmed PO Delivery > 0 THEN POST(Suggested Order Amount for the Month, Shipping Time Weeks) ELSE 0

Try best practice

IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0

IF Confirmed PO Delivery <= 0 THEN 0 ELSE POST(Suggested Order Amount for the Month, Final Shipping Time Weeks)

POST(Suggested Order Amount for the Month, Final Shipping Time Weeks)

Tagged:

Comments

  • @ramas 

     

    If you are following the instructions from Level 2 document it asks you to pick up Suggested Order Amount for the Month initially and later when you create an override line item it asks you to replace Suggested Order Amount for the Month with Final Shipment Amount. Your second last formula is somewhat close but not right

     

    Few Corrections:

    It should be IF Confirmed PO Delivery > 0  and not <=0 because maximum times it will be > 0

    In POST syntax first parameter should be Final Shipment Amount & not Suggested Order Amount for the Month

    In POST syntax second parameter should be Final Shipping Time Weeks

     

    Hope that helps

    Misbah

  • Yes, it helped. Thank you so much 🙂

  • I had an issue as well. Here is the formula I was using.

     

    IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time in Weeks) ELSE 0

     

    Please let me know how far off I am. thanks.

  • Your formula is correct, looks like the line item name is wrong "Final Shipping Time in Weeks"

    Remove "in" and then try it again.

     

    Hope this helps!

  • @Misbah 

    Can you please explain your sentence "It should be IF Confirmed PO Delivery > 0  and not <=0 because maximum times it will be > 0".  I do not understand why you state the maximum times it will be greater than 0.  If an order is placed when needed, according to the Reorder Flag, an order is only placed 1 or 2 weeks of the 4-5 week month, so there are more instances where an order is not placed, resulting in a zero.  Wouldn't the best practice be "IF Confirmed PO Delivery = 0 THEN 0 ELSE ..."

    Thank you,

    Tracy

     

     

  • Came across this topic trying to search for correct test answer... I used....


    IF Confirmed PO Delivery = 1 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0

    I think this formula is working, but it is not working on the test, so I suggest using POST.