Set Analysis Is Not Null and another column is Null

[#1]

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

[tresB]

Try like:

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