How to add a discount item, discount applied item, and discount amount into the saved search

On the Results subtab, click Columns.

For adding Discount Item:

Select Formula(Text) from the list. In the Summary Type field, select Group

CASE WHEN {item.class}=’Specify the discount name here‘ THEN {item} ELSE ” END

For adding Discount Applied Item:

Select Formula(Text) from the list. In the Summary Type field, select Group

CASE WHEN nvl({discountamount},0)!=0 THEN {item} WHEN(NVL({grossamount},0)-NVL({netamount},0))>0 THEN {item} ELSE ” END

For adding Discount Amount:

Select Formula(Currency) from the list. In the Summary Type field, select Sum

NVL({discountamount},{grossamount}-{netamount})