Forum Stats

  • 3,722,784 Users
  • 2,244,413 Discussions
  • 7,850,085 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Percentage Shipping cost/Sales order amount

CK43213
CK43213 Member Posts: 1 Green Ribbon

I am creating a saved search to display the percentage of the shipping cost in the sales order amount. and I came up with this following formula:(NVL({custbody_pacejet_freight_costcurrency},0)) / NULLIF({createdfrom.amount},0) and it works fine when it's only 1 sales order with 1 tracking number. When it comes to several orders shipped under 1 shipment, the formula returns a value for just the sales order where the shipping cost is applied.

I would like to compute all the orders shipped together and apply the formula. Any assistance would be much appreciated. Thanks

Answers

Sign In or Register to comment.