title: How do I deterimine if a double is not infinity, -infinity or Nan in SSRS?
body: <p>If got a dataset returned from SSAS where some records may be infinity or -infinity (calculated in SSAS not in the report).</p>
  
  <p>I want to calculate the average of this column but ignore those records that are positive or negative infinity.</p>
  
  <p>My thought is to create a calculated field that would logically do this:</p>
  
  <pre><code>= IIF(IsInfinity(Fields!ASP.Value) or IsNegativeInfinity(Fields!ASP.Value), 0 Fields!ASP.Value)
  </code></pre>
  
  <p>What I can't figure out is how to do the <code>IsInfinity</code> or <code>IsNegativeInfinity</code>.</p>
  
  <p>Or conversely is there a way to calculate Average for a column ignoring those records?</p>