Anyone know how to grab the SUBTOTAL field in a transaction saved search? We're trying to build a search that shows all sales orders and invoices within a date range (filter) and we need the subtotal from the SO. The "Amount (Net of Tax)" field has two problems - 1) it's empty when no tax was charged on the order and 2) it includes shipping charges. We're looking for a subtotal on just the items.

Can you use {amount} - NVL({shippingamount},0) - NVL({taxamount},0)?

@Erik that wasn't exactly it, but it was close enough for me to figure it out! Just needed to change taxamount to taxtotal... {amount} - NVL({shippingamount},0) - NVL({taxtotal},0) THANK YOU!