<div>
Looks like divide by zero error.
</div>


<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I am using the following expression within SSRS to work out a percentage but I am getting the value of 0.0% when I know that is inncoorect. Could you please take a look at the query below an d tell me where I am going wrong<br />
<br />
=iif(Fields!Stage_Name.Val<wbr />ue = &quot;Stage 99 - Funded Loan&quot;, iif(sum(Fields!Stage_Count<wbr />.Value) = 0, 0, sum(Fields!Stage_Count.Val<wbr />ue)), 0) / iif(Fields!Stage_Name.Valu<wbr />e = &quot;Stage 1 - App Started&quot;, iif(sum(Fields!Stage_Count<wbr />.Value) = 0, 0, sum(Fields!Stage_Count.Val<wbr />ue)), 0)
</div>
</div>


Hi 

I am using the following expression within SSRS to work out a percentage but I am getting the value of 0.0% when I know that is inncoorect. Could you please take a look at the query below an d tell me where I am going wrong

=iif(Fields!Stage_Name.Value = "Stage 99 - Funded Loan", iif(sum(Fields!Stage_Count.Value) = 0, 0, sum(Fields!Stage_Count.Value)), 0) / iif(Fields!Stage_Name.Value = "Stage 1 - App Started", iif(sum(Fields!Stage_Count.Value) = 0, 0, sum(Fields!Stage_Count.Value)), 0)

SSRS Percentage calculation

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.