Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to display the count of null values of Account Number.
What is the expression to calculate that.
Hi,
This will count both nulls and blanks:
count(if(len(trim([Account NUmber]))=0,[Account Number]))
May be this:
NullCount([Account Number])
NullCount([Account Number])
Hi,
This will count both nulls and blanks:
count(if(len(trim([Account NUmber]))=0,[Account Number]))
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))