How to count null records in each field sing System table

[bhupesh_gupta]

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

[Chanty4u]

use

=Nullcount(yourfield)

[bhupesh_gupta]

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