Any idea why it is not counting null field =Count(IIF((Fields!GrantTotal.Value) = "0",1,Nothing)) simam

Null is not equal to 0. If you need to check for null values, use IsNothing =Count(IIF(IsNothing(Fields!GrantTotal.Value) OR (Fields!GrantTotal.Value) = "0",1,Nothing))

JL, Thank you , how about If I like to check for null values count. =Count(Fields!GrantTotal.Value) Thank yousimam

The COUNT function counts all values EXCEPT for null/nothing. To count the number of null values: =Count(IIF(IsNothing(Fields!GrantTotal.Value),1,Nothing)) I believe this should also work (not tested) =Sum(IsNothing(Fields!GrantTotal.Value))

JL I like to count number of grant even if row is null. Grant Null 1 2 3 Count should be 4. Thank yousimam

So basically, you want to count the number of rows? Try =Count(1)

Yes I like to count the number of rows. Right now I am using Count(Field.Grant.Value) but it is not picking the null rows. Thank yousimam

As mentioned, COUNT function does not include null values. Try using a constant value as parameter instead. i.e. =COUNT(1)

Sorry , I am not getting =count(1) - where is the field name like I have = Count(Field.Grant.Value)simam

Why do you need to specify the field name if you are counting all records? Or maybe you want to count distinct/unique values? If so, try =CountDistinct(Iif(IsNothing(Field.Grant.Value),"",Field.Grant.Value))