SAVED SEARCH ISSUE: Very confusing for me. Below is the result of the Saved Search which shows a discount being applied to each line. That discounted amount for each item shows under the results (amount column) of the saved search as attached on another screenshot. Not sure how is it able to get that on the line level. What I want to do is basically display the difference of the actual price and discount in a new field but unable to find the regular/actual price to show in the results. Sorry for the brain drain but really confused here. Appreciate any help.

Try restrict your criteria under "Item Fields..." to Type = Inventory Item, then depending on how that discount has been applied you may get it as Amount (Net) vs Amount, though I fear your set up is adding each line discount by adding an additional discount item line - which makes this way tougher!

ah gotcha