I need to calculate the amount difference in two line items on a saved search. basically the 1st item is the regular product and second item is a promo line. Subsequently, 3rd item would be the product and 4th item would be the promo line. How can I proceed. Thanks in advance.

Saved Searches can't compare 2 different results in the way I think you are asking. Each result is its own isolated data set. That being said you can use a summary result of 'Sum' to have the search add all the values in a column together and display the total by the summary 'Group' results. Depending on what the data is being used for there are some summary search tricks that may give you what you want.

Makes sense. thats what I thought too. Our 3 PL uses the saved search for item fulfillment and they only get the unit price of the item. We are in Canada and if something is shipped to States our customer would have to pay duties if order exceeds 800 dollars since on the commercial invoice everything would be regular price even though customer paid discounted price

What about the field 'Amount (Transaction Total)'?

thanks David. it basically gives the summary price but on the commercial invoice there needs to be detailed pricing.

Good luck Amtoj. Celigo has some data transformation ability that may be able to do exactly what you need as well.