Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some data with Null values to report on and unable to figure out the correct expression.
I want to see only data with NO implementation partner associated.
I'm able to see all data WITH an implementation with the following expression:
=count ({< Type = {'*Onboarding*'}, [Implementation Partner] = {'*'}>}[Success Plan: ID])
Simply adding '-=' for Implementation Partner does not produce the opposite result. For some reason this zero's out the results. Any clues, this seems like it should be easy?
=count ({$<Type = {'*Onboarding*'}> - <[Implementation Partner] = {'*'}> }[Success Plan: ID])
May be try this?
=count ({< Type = {'*Onboarding*'}, [Implementation Partner] = {' '}>}[Success Plan: ID])
=count ({$<Type = {'*Onboarding*'}> - <[Implementation Partner] = {'*'}> }[Success Plan: ID])
Thanks but for some reason, Anil, this brings back all data, including those WITH Partners associated.
are you sure, you're using real null() values?
What if you are getting when use like below
=count ({< [Implementation Partner] = {' '}>}[Success Plan: ID])
OR
=count ({< [Implementation Partner] = {'0'}>}[Success Plan: ID])
OR
=count ({< [Implementation Partner] = {'-'}>}[Success Plan: ID])
OR
=count ({< [Implementation Partner] = {"=Len([Implementation Partner])>0"}>}[Success Plan: ID])