<div>
<div class="content wysiwyg-content">
I am trying to remove the NaN from this report item and can't seem to get it right. &nbsp;Here is the expression.<br />
=IIF(IsNumeric(Sum(Fields!<wbr />excessiveN<wbr />oiseResolv<wbr />ed.Value)/<wbr />sum(Fields<wbr />!excessive<wbr />Noise.Valu<wbr />e)),Sum(Fi<wbr />elds!exces<wbr />siveNoiseR<wbr />esolved.Va<wbr />lue)/sum(F<wbr />ields!exce<wbr />ssiveNoise<wbr />.Value),10<wbr />0)
</div>
</div>


I am trying to remove the NaN from this report item and can't seem to get it right.  Here is the expression.
=IIF(IsNumeric(Sum(Fields!excessiveNoiseResolved.Value)/sum(Fields!excessiveNoise.Value)),Sum(Fields!excessiveNoiseResolved.Value)/sum(Fields!excessiveNoise.Value),100)

Trouble with NaN

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.