INV01 Line Item;Shipping Cost




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 


  • Hi @neg177 


    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 . 



    Puneeth HP 

    Success is the Intersection of Dreams and Hardwork!