Hello, thats what i wrote. but i needed something different.it is like this.when the denominator is zero it is displaying "Nan"
i dont wnat this way in the report.
I have an expression like this in ssrs. It display nothing when
(Fields!Survey_Completed.Value)/(Fields!Email_Invite_Sent.Value)=0
But and value when the result of this is some value. But I wanted to have nothing whne the denominator is zero.
Can anyone help me with this?
The expression that I have now is this which does not displays what I want.
=iif((Fields!Survey_Completed.Value)/(Fields!Email_Invite_Sent.Value)=0," ",(Fields!Survey_Completed.Value)/(Fields!Email_Invite_Sent.Value))
thank you