Expression to exclude two account numbers

[fislar20]

I am trying to write an expression to exclude Account numbers 30642 and 30644 from my report results

I thought the initial selection should be written

<>'30642,30644'

or

'<>30642,30644'

but both do not work

Any suggestions?

[Vegar]

You could try something like this: (Assuming that your expression is Sum(Amount).

Sum({<[Account number] -= {"30642", "30644"}>} Amount)

If you are to do the logic in the script then you can use logic like below.

IF(NOT match([Account number], '30642', '30644'), Amount) as [Special amount],

[fislar20]

No, I am not summing anything, this is a dimension, that I want exclude

[Vegar]

Try an expression similar to this:

=aggr(if(NOT match(only({1}[Account number]), '30642','30644'),only({1}[Account number])),[Account number])