I have been banging my head against a search for a couple days now, and not sure what to do. It seems pretty simplistic, here's the scenario: Starting with a transaction search, type: sales order, i need the

{amount} - {shippingamount}

and then from applying transaction item fulfillment I need the sum of a custom field called

freightcost

which is written to our item fulfillment from our shipping software. The problem comes in that there may be multiple item fulfillments from one sales order... I need the sum up all of the

freightcost

fields from all of the item fulfillments for that sales order WITHOUT duplicating or triplicating the sales order

{amount} - {shippingamount}