Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts
In one of my new requirement, I want to create a straight table which will have $field as my dimension and want to know the count of null records in each field.
I was trying the below expression but it is not giving me all the fields with the NULL records count
$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',count({1<[' & $Field & ']={""}>}[' & $Field & '])', ',') & concat(right($Field&')',1)))
Please note that my table has 30 different fields , and all are having few Null records in them, but above expression only show 10 fields with the correct result.
Kindly help me in narrow downing the root cause.
Regards
Bhupesh
use
=Nullcount(yourfield)
Hi Chanty
As I said I have 30 + fields in my system table , so I can't mention each and every field name separately in every expression
Regards
Bhupesh