L2 Sprint 3 3.3.6 Activity: Test the Shipping Cost Formulas
Hi,
I have been trying to test the shipping cost formulas and cannot seem to figure this out, and I've identified that other formulas are incorrect, too. Could someone please review and help point me in the right direction? I am attaching a screenshot of my BP view as well as data to show where my figures are not aligned with the example. Any help is greatly appreciated.
Formulas I have used where there is variance:
Confirmed purchase order receipt: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipment Amount
Shipping costs: Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
Final shipping costs: Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]
Shipping cost variance: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipment Amount
Best Answer
-
Hi,
Unfortunately, I can't access the screenshots right now, but in regard to your formulas I believe they should look like this:
Confirmed Purchase Order Receipt: IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0
Shipping costs: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping time (week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
Final Shipping costs: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping time (week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]
Shipping cost variance: IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs
I see we've a difference on the PO receipt, if you alter this are you able to reconcile the numbers?
Adam
3
Answers
-
Thank you so much! The formula update for the PO fixed it, along with removing my overrides from a previous lesson. Thanks again!
0 -
No worries, glad it helped
0