Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
=sum({($ -<B={'*'}>) * <A={'*'}>} ID)