<div>
Use<br />

<pre><code id="code-20-40473358-1">=iif(sum(Fields!EstHours.Value) = 0,1,sum(Fields!ACT_COMP_HRS.Value)/sum(Fields!EstHours.Value))</code></pre>
<br />
to avoid the error.
</div>


Use


=iif(sum(Fields!EstHours.Value) = 0,1,sum(Fields!ACT_COMP_HRS.Value)/sum(Fields!EstHours.Value))


to avoid the error.

<div>
no it doesn't, that will still result in Divide by zero...
</div>


no it doesn't, that will still result in Divide by zero...

<div>
Thank you, this works just as required.
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have an expression on a report as follows:<br />
<br />
=iif(sum(Fields!EstHours.V<wbr />alue) = 0,&quot;N/A&quot;,sum(Fields!ACT_COM<wbr />P_HRS.Valu<wbr />e)/sum(Fie<wbr />lds!EstHou<wbr />rs.Value))<wbr /><br />
<br />
From time to time, the value of EstHours is zero. When this occurs, my expression returns a #Error as opposed to the N/A I require. I understand this is because the iif statement needs to evaluate the whole expression which includes the divide by zero. My question is, how do I remedy this?<br />
<br />
Thanks in advance
</div>
</div>


Hi all,

I have an expression on a report as follows:

=iif(sum(Fields!EstHours.Value) = 0,"N/A",sum(Fields!ACT_COMP_HRS.Value)/sum(Fields!EstHours.Value))

From time to time, the value of EstHours is zero. When this occurs, my expression returns a #Error as opposed to the N/A I require. I understand this is because the iif statement needs to evaluate the whole expression which includes the divide by zero. My question is, how do I remedy this?

Thanks in advance

#Error when using iif statement with divide by zero

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.