Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a KPI that simply counts the number of NULL values in a field. The table has over 10,000 rows and looking at the preview I can see a lot of NULLs in the field of interest.
RangeNullCount() finds the number of NULL values in an expression or field, so I thought that might be what I need, but RangeNullCount(field_name) returns 1. I must be doing something wrong.
How do I count the number of rows with a NULL value?
Thanks in advance.
Perhaps NullCount() would work here? RangeNullCount() needs a range, and a field is not a range, so it wouldn't do the job here.
If there's a non-null field in the same table as the field, you could also use Count(NonNullField)-Count(NullField), presumably.
Perhaps NullCount() would work here? RangeNullCount() needs a range, and a field is not a range, so it wouldn't do the job here.
If there's a non-null field in the same table as the field, you could also use Count(NonNullField)-Count(NullField), presumably.
Yes, that's the function I need. Also the values were not actually NULL but contained 'NULL' instead. I had to Set Nulls on NULL in the Data Manager. Now I have the correct count.
Thanks,
Dan