I'm confused on the Line Item Formula above. Please advice.
'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:(Final Shipping Cost/1000)*'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units']
You should be multiplying Final Shipment Amount / 1000 & cost per 1000 units looking up to Product and shipping method .
In lookup we should be doing any calculations .
We are dividing Final shipment amount by 1000 because we need to get the Final Shipment amount of single Unit .