InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:45:44 GMT20http://www.sqlservercentral.com/Forums/Topic986345-1633-1.aspxHi,Custom code gives u more accurate results in your requirment pinky.Veeren.Wed, 22 Sep 2010 01:37:41 GMTveeren4urshttp://www.sqlservercentral.com/Forums/Topic986345-1633-1.aspxThanks for Replying me.Thu, 16 Sep 2010 16:42:45 GMTcpinky01http://www.sqlservercentral.com/Forums/Topic986345-1633-1.aspxTry this instead[quote]=IIF(Fields!Records_Included.Value = 0, "", IIF(Fields!Interview_Completed.Value/Fields!Records_Included.Value = 0, "", Fields!Interview_Completed.Value/Fields!Records_Included.Value))[/quote]Or if you use this kind of calculation a lot, many of us do you could go to Report>>Report Properties and choose the Code tab and put something like this function in there:[code="other"]Public Function DivideBy(ByVal Exp1, ByVal Exp2) If Exp2 = 0 Then DivideBy = "" Else: DivideBy = Exp1/Exp2 End IfEnd Function[/code]Then in your SSRS expression you would put[code="other"]=code.DivideBy(Fields!Interview_Completed.Value, Fields!Records_Included.Value)[/code]and it would all work out just fine. PS. I found this function code either on this site or elsewhere on the internet. I found it extremely useful and it is now part of my report template.Thu, 16 Sep 2010 07:16:28 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic986345-1633-1.aspxHello, 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)=0But 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 youWed, 15 Sep 2010 16:27:40 GMTcpinky01http://www.sqlservercentral.com/Forums/Topic986345-1633-1.aspx[quote]=IIF(Fields!Interview_Completed.Value/Fields!Records_Included.Value = 0, "", Fields!Interview_Completed.Value/Fields!Records_Included.Value)[/quote]Wed, 15 Sep 2010 13:31:38 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic986345-1633-1.aspxHi,In one column I am calculating this.=Fields!Interview_Completed.Value/Fields!Records_Included.ValueThis is the percentage.When this is 0% IT HAS TO BE BALNK. MEANS IT SHOULD NOT SAY 0%. How can we write an expression in ssrs for this?Thank youWed, 15 Sep 2010 08:52:25 GMTcpinky01