question on count in set analysis expression

[gerrycastellino]

I need to structure an expression where I'm counting all distinct 'A'   based on 'B'  being not null,  for the entire data set:

Count( DISTINCT { < B = {"*"}>}  {1}  A)

just wanted to confirm if this will work ...

Gerry

[sunny_talwar · Accepted solution]

Not sure about this hanging {1}, but this should work:

Count(DISTINCT {<B = {'*'}>} A)

or if you want to ignore any selection, then a 1 like this:

Count(DISTINCT {1<B = {'*'}>} A)