IsNothing is not working for me

[sandipghosh2]

Hi,

I am using below expression:

It is not working for me. When I have value in M3_Gross_Sales_Contract_Entity.Value, it is showing % value.

I am also using below expression:

IIF(SUM(Fields!M3_Gross_Sales_Contract_Entity.Value) = 0 AND Fields!M3_Gross_Sales_Contract_Entity.Value="", 1,
(Sum(Fields!M4_Gross_Sales_Contract_Entity.Value, "Main")-SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main"))/SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main"))

when I have value in M3_Gross_Sales_Contract_Entity field, it is showing %value , but when there is no value in: M3_Gross_Sales_Contract_Entity, it is showing #error

Thanks,

Sandip

[hackcrr · Accepted solution]

Hi, @sandipghosh2 

You can use IIF statements or the IIf function in Paginated Reports to check for those conditions before performing the division. Here's an updated version of your expression:

=IIF(
    SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main") = 0 OR IsNothing(Fields!M3_Gross_Sales_Contract_Entity.Value), 
    0,  -- Or you can return a default value such as "N/A"
    (SUM(Fields!M4_Gross_Sales_Contract_Entity.Value, "Main") - SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main")) / SUM(Fields!M3_Gross_Sales_Contract_Entity.Value, "Main")
)