How to include nulls and exclude a specific value?

[Anonymous]

Hi,

I have a table that will count the IDs, but I need to exclude some values, the problem is that the field may have nulls or blanks.

I am using something like this:

count({$<[Code] -= {'Test'}>}[Case Count])

When I use something like that, it will also remove from the list the ones that are null. How can I use a similar expression that not exclude nulls?

Please let me know.

[swuehl · Accepted solution]

Maybe

Count({$<[CaseId] = e({<Code = {'Test'}>} )>} [Case Count])

Excluding values in Set Analysis

[sunny_talwar]

Or this:

Count(If(Code <> 'Test', [CaseCount]))

[Anonymous]

Thank you for your answer, this is working!!!!

[sunny_talwar]

And this did not work?

Count({$<CaseId= {"=Code <> 'Test' "}>}[Case Count])

swuehl‌ is there a difference between the above and your expression?

[sunny_talwar]

I am not sure what might have gone wrong, but seems like most of the things I proposed are working on this sample . But I might not know your data well enough to comment more

[Anonymous]

It worked but excluded the nulls, the one from Stefan didn't excluded the nulls. Thank you both for your help.

[sunny_talwar]

Thanks for getting back .

If you look at the sample attached below, I don't see that behavior.... Anyways in the end you got what you wanted.

Best,

Sunny