I have an expression like this in my report....
iif(Isnothing(Fields!Suminsured),0,Fields!Suminsured) / iif(Isnothing(Fields!No.ofRisks),0,Fields!No.ofRisks) ..When I am giving expression like this....It showing NaN in some rows...But I don't want NaN...That is why I am checking for Isnothing() condition...If
its nothing I am placing zero 0...
Both Fields!Suminsured and Fields!No.ofRisks are integer fields.
But the above the expression is giving NaN in some rows... I want to avoid that....Can anyone let me know how to acheive this ...?
Apprecaite ur help.
Waiting for the reply
View Complete Post