3.3.5.3 Check Your Work - I don´t understand were I´m wrong.
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:
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:
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.
Answers
-
Hi @OscarSalazar ,
There seems to be a problem final shipping time weeks lineitem.
Can you share the formula for the same?
Regards,
Venkatesh0 -
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.
0