Sum with multiple conditions

[aria_123]

How do I sum based on multiple conditions?

I only want the approved and pending Status sum cost from Type=issue.  

Type == Issue  AND (Status != "Rejected" OR  Status !="Rejected")

    =Round (Sum ({<Type={'Issues'}, Status -={'Rejected'} , Status -={'Canceled'}>} [Cost Ratio]), 0.01)

But with this, I keep getting the "Rejected" ones.   It does exclude the "Canceled" items. 

[Vegar]

Try this expression:
=Round (Sum ({<Type={'Issues'}, Status -={'Rejected','Canceled'}>} [Cost Ratio]), 0.01)

[jonnaamb · Accepted solution]

Hello Aria,

The same modifier cannot be given twice in one expression. When you give 'Status' twice, it is considering the second 'Status' as null. I've attached a screenshot as to how Set Analysis can be remembered easily. 

The ideal expression would be this:

=Round (Sum ({<Type={'Issues'}, Status -={'Rejected','Canceled'}>} [Cost Ratio]), 0.01)

Best regards,

Ambareesh

[aria_123]

Wow.  Thanks for quick responses.   It works!