Have been trying the Shipping cost variance formula but could not crack it. Help?
Hello @Winter01 ,
Without having the purpose in front of me, I understand that this value:
I hope the lines above were clear enough. If you still have doubts do not hesitate to keep asking!
Is the above formula right?
I also applied this.
IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs is the correct formula
Can anyone please help me with Shipping Costs formula in sprint 3 activity 188.8.131.52
Hello @Sagar17 To calculate Shipping costs, we require Shipment amount, Shipment cost by shipping method by Product. Here the formula u can reference.
Final Shipment Amount * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product] / User Selections.Shipping Costs items count