Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Or this:
Count(If(Code <> 'Test', [CaseCount]))
Thank you for your answer, this is working!!!!
And this did not work?
Count({$<CaseId= {"=Code <> 'Test' "}>}[Case Count])
swuehl is there a difference between the above and your expression?
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
It worked but excluded the nulls, the one from Stefan didn't excluded the nulls. Thank you both for your help.
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