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

Options
ramas
ramas Member, ALL USERS, Community Member Posts: 2 New Contributor
in Anaplan Community

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)

Comments

  • mmounika
    mmounika Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Yes, it helped. Thank you so much 🙂

  • mmounika
    mmounika Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    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!

  • JimMcL
    JimMcL Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor

    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.

  • tracy.milbrath
    tracy.milbrath Member, ALL USERS, GroupMember, Certified Model Builder Posts: 1 New Contributor

    @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

     

     

Categories