Exclude in Set Analysis

[#1]

Hi

I want to exclude specific GL Codes from Invoice Amount.

For e.g.

sum({$<[GL Code]=E({'ABC',XYZ'})>}[Invoice Amount])

Any idea how I can achieve this?

[swuehl · Accepted solution]

Try

=sum({$<[GL Code] -= {'ABC',XYZ'} >}[Invoice Amount])

and ignore the bug in the expression editor highlighting the minus equal as error.

[#3]

Worked. Thanks