Line Item Shipping Cost INV01

Highlighted
Frequent Contributor

Line Item Shipping Cost INV01

Hi,

 

I need guidance on writing the Formula for this Line Item. My formula is below. 

 

'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:Shipping Method}

 

Thank You 

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Line Item Shipping Cost INV01

@neg177 

 

This doesn't seem to be quite right. Please go through the requirements once again.

 

You need to take Final Shipment Amount * 1000 in numerator and then divide that by below formula

 

Also below formula is incorrect: One of the LOOKUPs is incorrect

 

Misbah