Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)