Count of Null values

[#1]

Dear Friends,

I would like to display the count of null values of Reason Codes,  like Reason Code it may contains alpha and numeric characters.

the following expression shows hypen only. I don't know where I am making a mistake. Can any one help me.

=If(Isnull([Reason Code]),Count([Reason Code])) .

Regards

Joe

[SunilChauhan]

hope one of below help

count( if(Isnull([Reason Code]),[Reason Code]))

or

count( if(Isnull([Reason Code])=-1,[Reason Code]))

or

count( if(Isnull([Reason Code])<>0,[Reason Code]))

or

count( if(len([Reason Code])=0,[Reason Code]))

[its_anandrjs]

Hi,

You have to use some thing below

=If( Isnull ( [Reason Code] ) = -1 and  [Reason Code] = 0, Count([Reason Code] ) )

Let me know about this.

Hope this helps

Rgds

Anand

[#4]

Hello,

Thanks for your help, I tried all the expressions in the above, but still its not working now the result is 0.

In the source Reason Code it may contain either values like alpha and numeric or no value like a empty cell.

I would like to display the count of empty cells.

Regards

Joe

[SunilChauhan]

try this

count( if([Reason Code])=' ',[Reason Code]))

or else anand chouhan will help

[#6]

Try this ;

SUM(IF([Reason Code]='',1,0))

[Anonymous · Accepted solution]

This will count both nulls and blanks:
count(if(len(trim([Reason Code]))=0,[Reason Code]))

[#8]

Dear Michael,

Perfect answer, now its working fine..............

Thanks a lot.

Joe