Blank values causing set analysis issue

[#1]

I have the following expression

=COUNT(DISTINCT {$<Firm-={"ICAP","*TEST*"}>}SessionId)

Unfortuantely records where the Firm field is blank are not being counted. How can i get them counted, whilst simutaneously ignoring the two values stated above?

[#2]

Maybe try....
=COUNT(DISTINCT {$<Firm-={"ICAP","*TEST*"}, Firm={*}>}SessionId)

[#3]

no luck

[#4]

Are you able to post a sample of the data or QVW? 

[Nicole-Smith]

You should have single quotes around the values instead of double quotes:

=COUNT({$<Firm-={'ICAP','*TEST*'}>}DISTINCT SessionId)

[#6]

=COUNT(DISTINCT {$<Firm-={"ICAP","*TEST*"}> + <Firm=p(1-$<Firm={"*"}>Firm)> }SessionId)

[#7]

I just created a sample file and it works. I did get the blank value count included. May be you want to post a sample showing data? I have attached my sample file for your ref.

[eduardo_sommer]

Hi Alex,

Is your value really blank? Make sure it is not null.

Eduardo

[#9]

Thanks Nicole. I tried this but it still didn’t work.

Out of interest, what’s the difference between apostrophies and speech marks?

[#10]

That's a great point Eduardo. The values are showing as -

Does that mean null or blank? What difference would this make to my expression?