3.3.6 Check your work

akrem
akrem
in Academy Discussions

Looks like my shipping costs are not calculating correctly ?

Shipping Costs:

Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Final Shipping Costs

Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[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

image.png

Best Answer

  • umangsinghal
    umangsinghal
    Answer ✓

    Formula for Shipping costs would be:

    Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

    Regards,

Categories