Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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],
No, I am not summing anything, this is a dimension, that I want exclude
Try an expression similar to this:
=aggr(if(NOT match(only({1}[Account number]), '30642','30644'),only({1}[Account number])),[Account number])