title: REPLACE Nan in SSRS
body: <p>I have the following issue in SSRS when I'm doing the following calculations.</p>
  
  <p>For the columns under Total Number - I'm doing the following - </p>
  
  <pre><code>=SUM(IIF(Fields!CallbackStatus.Value="Completed",1,0))
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=SUM(IIF(Fields!CallbackStatus.Value="Outstanding",1,0))
  </code></pre>
  
  <p>In this particular example  - the Total number of Callbacks is 0.
  Why by using the above expression would the below not pull back a 0 and instead a blank field.</p>
  
  <p>Also in the % of Total I'm getting NaN. I'm also wanting that to be 0 if it's NaN.
  The functions for this is below - </p>
  
  <pre><code>=ReportItems!Textbox57.Value / ReportItems!Textbox54.Value
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=ReportItems!Textbox61.Value / ReportItems!Textbox54.Value
  </code></pre>
  
  <p>any help would be great. Thanks</p>
  
  <p><img src="https://i.stack.imgur.com/ktmKO.jpg" alt="report"></p>