3.3.5.3 Check Your Work - I don´t understand were I´m wrong.

Options
OscarSalazar
OscarSalazar
in Modeling

I have done all formulas and checked my work against the course examples and everything was good until I review the Nutzo Bar_En selecting the Submit Purchase Order Request? I get the following:

image.png

The example given in the course says that the confirmed Purchase Order Receipt for Jan20 should be 8,194 but I get 8,396 (same as in week 5), I double checked my formulas and I don´t know what I´m missing, my formulas are set as following:

image.png

I kept going a couple of lessons further, but I don´t want to keep going having that error and not getting the correct amounts.

Thanks.

Tagged:

Answers

  • Venki9902
    Venki9902
    Options

    Hi @OscarSalazar ,

    There seems to be a problem final shipping time weeks lineitem.

    Can you share the formula for the same?

    Regards,
    Venkatesh

  • OscarSalazar
    OscarSalazar
    Options

    Hi @Venki9902,

    Thanks for your answer, my formula for "Final Shipping Time Weeks " is:

    'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

    But I made a change in the "Confirmed Purchase Order Receipt" Line Item that was creating my issue, the new formula for this line item is:

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

    With these changes and some others I Think I got everything on spot now.

Categories