Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this in your expression:
sum({<Status-={'*Rejected*'}>}InvoiceAmnt)
Cheers,
Shyam
Sum({$<Status={'Pending'}>}InvoiceAmount).
Best Regards,
Vishal
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%)
Try this in your expression:
sum({<Status-={'*Rejected*'}>}InvoiceAmnt)
Cheers,
Shyam
Thanks it works,
How can I filter the Rejected and Cancelled in Status field from the report as per the attached image.