Discount Amount using Saved Search

Go to List -> Saved Search -> Saved Searches -> New -> Transaction

Under the criteria subtab:

• Add field Item fields… -> Type -> Discount Item

Under Results subtab:

• Add Amount column
• The summary Type is Sum

If we want to use the formula for getting Discount Amount in the Results:

CASE WHEN {item.type}=’Discount’ Then {amount} ELSE 0 END