INV01 Line Item;Shipping Cost

neg177
neg177
in Modeling

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 

Tagged:

Comments

  • Puneeth H P
    Puneeth H P

    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 . 

     

    Thanks,

    Puneeth HP 

Categories