Level 2 - SPrint 3 - 3.3.6

Yogitha
Yogitha
in Academy Discussions

Attaching below are what is expected and what i got, need assistance regarding this.

 

Let me know if i have to attach my formulas too2022-10-27 (1).png2022-10-27 (3).png

Tagged:

Comments

  • AdamCookson
    AdamCookson

    Hi,

     

    From the screenshot I believe your calculations are correct, but in comparison to the 'Check your work' example you seem to have different order requests and overrides selected. If you change these to match the example shot, do you match? If not, could you share a screenshot of your blueprint and I'll take a look.

     

    Hope this helps.

  • Yogitha
    Yogitha

    I  made few changes and I guess I have trouble only  with ' Confirm Purchase Order Receipt'.

    I  am attaching the snapshot of it 

     

    My Confirm Purchase Order Receipt formula is:

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

     

     

    Let me know where and what I am missing.

     

    2022-10-27 (1).png2022-10-27 (7).png

  • AdamCookson
    AdamCookson

    I think if you swap your Confirm Purchase Order Receipt to the following you should get the correct result: IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

     

    Hope this resolves the issue.

  • Yogitha
    Yogitha

    Thanks, I think now it looks fine.

  • Yogitha
    Yogitha

    Confused with what to be done

    2022-10-27 (8).png

Categories