Need help with counting nulls

[#1]

Hi all,

I would like to display the count of null values of Account Number.

What is the expression to calculate that.

[sunny_talwar]

May be this:

NullCount([Account Number])

[#3]

NullCount([Account Number])

[nagireddy_qv · Accepted solution]

Hi,

This will count both nulls and blanks:

count(if(len(trim([Account NUmber]))=0,[Account Number]))

[swuehl]

Nagireddy.qv, I think you need to consider the case when [Account Number] is NULL, then your expression will count NULL which return zero. So you would need to return a value in these cases:

=count(if(len(trim([Account NUmber]))=0,'NULL'))

or

=Sum(if(len(trim([Account NUmber]))=0,1))