3.3.6 Level 2 Sprint 3

From the Training we are provided this example

FireShot Capture 022 -  - learning.anaplan.com.png

 When I tried to replicate the situation to move forward, I got this:FireShot Capture 023 - Anaplan - Level 2 Supply Chain Philip Cramer - us1a.app.anaplan.com.png1. 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