conditional Expression

[#1]

Attached is one of my simple expression which sums a column. Now I want to add a condition in the expression where it should sum the 'Invoiceamount' only when there is no word like 'Rejected' in the Status column.

With reference to the attached image, the red one should not be a part of sum

[#2]

Sum({$<Status={'Pending'}>}InvoiceAmount). 

Best Regards,
Vishal

[#3]

Thanks for the expression. But here I need a statement where it looks for a word 'Rejected' in a statement.

In SQL you will represent it as (Status like 'Rejected%)

[#4 · Accepted solution]

Try this in your expression:

sum({<Status-={'*Rejected*'}>}InvoiceAmnt)

Cheers,

Shyam

[#5]

Thanks it works,

How can I filter the Rejected and Cancelled in Status field from the report as per the attached image.