I am building a report wherein i am calculating the sum of a particular field in the report. The problem is that this field at times may also be null and it displays #Error when this is the case. I have tried using isnothing but it is not working for me. Is there any way i can check if the field is null before i do the calculation.

Hi, Can you throw some more light? with your expression too? Thanks KumarKG, MCTS

my expression goes as : sum(iif(Fields!acb.value="something",Fields!quantity.value,0) The problem is quantity may be null in some cases and i get an error when thats the case. How do i ensure that i take the sum of quantity only when it is not null.

Hi, try this, = SUM ( IIf ( Fields!acb.value="something", IIf ( IsNothing(Fields!quantity.value ) OR Fields!quantity.value = "", 0, Fields!quantity.value ), 0 ) Please lets us know your feedback. Thanks KumarKG, MCTS