3.3.6 Level 2 Sprint 3
From the Training we are provided this example
When I tried to replicate the situation to move forward, I got this:1. Why does Production Order have blue 0s from training material if we put it in as "No Data"?
2. Where did I go wrong with my Shipping Costs Formula?
Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
3. Where did I go wrong with Final Shipping Costs Formula? I assume I made similar mistake on above formula since I based this one off of that.
Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]
4. I am hoping Shipping Cost Variance is fixed by above formulas, but also feeling unsure about that formula now.
IF NOT Override Shipping Method THEN 0 ELSE Shipping Costs - Final Shipping Costs
Thanks in advance!
Comments
-
Also, need assistance here.
0