IsNothing not working on empty value in report bui

Question

I have an expression in a table that checks if there was a return value.

If the query returns empty or null I want to set the value to 0.

=IIF(IsNothing(Fields!DndCount.Value),0,Fields!DndCount.Value)

But if the query returns empty IsNothing() does not work.

Answer 1

I have tried this code and it worked for me.

IIF(Sum(Fields!DndCount.Value)Is Nothing, "0", Sum(Fields!DndCount.Value))

Answer 2

You can also try to use the IsMissing expression of the field,

like this:

=IIF(Fields!Accounting_Amount.IsMissing, 0, Fields!Accounting_Amount.Value)

Answer 3

Alternative solution to avoid using expressions, change the cell format to #,##0 in properties. Easier then to pair it up with count or sum.

Answer 4

Try this:

=IIF(Fields!DndCount.Value=0 OR 
IsNothing(Fields!DndCount.Value)=0 OR
Fields!DndCount.Value="null",0,Fields!DndCount.Value)

Answer 5

Since IsNothing will return a True or False value you need to set your expression as:

=IIF(IsNothing(Field1) = True, 0, Field2)   

Hope it helps.