Set Analysis Is Not Null and another column is Null

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to write a set analysis where I'm counting where column A is not null and where column B is null.

I can only get the one part write.

I have tried the following:

=sum({($ -<B={'*'}>) * <A={'0'}>} ID)

=if(isnull(A),count(DISTINCT{$<B={'*'}>}ID))

Thank you

Re: Set Analysis Is Not Null and another column is Null

tresB — Thu, 21 Jul 2016 11:24:01 GMT

Try like:

=sum({($ -<B={'*'}>) * <A={'*'}>} ID)