Calculating Subtotal amount for transaction saved searches:

Subtotal of a transaction record cannot be retrieved by using it’s internal Id, instead we need to use a formula.

In a transaction saved search, add all required values in criteria tab and result tab.
For subtotal, add either of formulas shown below:

Formula = {amount} – nvl({taxtotal},0) – nvl({shippingamount},0)
Label = Subtotal

Alternative for Formula (Currency):

- Formula (Numeric) = nvl({totalamount},0)-nvl({discountamount},0)-nvl({taxtotal},0)-nvl({shippingamount},0)
    Label = Subtotal

Note: The Subtotal is net of discount if added as line item.