INV01 Line Item;Shipping Cost

[neg177]

Hi,

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']

Thank you

[Puneeth H P]

Hi@neg177

你应该乘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 .

Thanks,

Puneeth HP