Level 2 Sprint 3 INV01 Inventory Ordering
1. Shipping Costs = Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
Is there any problem with this formula?
2. Safety stock Target = WEEKVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock)
Safety Stock Exception Count = IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0
I am getting '0' as values for safety stock target.
Anything I have got to correct here?