title: SSRS hide #Error displayed in cell
body: <p>I am doing computations on that data that will result in #Error at times. The underlying cause is a divide by zero. I could jump through the necessary work arounds to avoid the divide by zero, but it might be simplier to mask the #Error text and show a blank cell. Is it possible to hide the #Error and just display nothing?</p>
  
  <p>Edit</p>
  
  <p>The expression for the text  might display #Error is something along these lines:</p>
  
  <pre><code>Fields!Field1.Value / Fields!ValueThatMightBeZero.Value
  </code></pre>
  
  <p>I could work around this with some ugly checking, but it might be easier to just catch the #Error.   (A straight <code>iif</code> check around the express doesn't work because SSRS evaluates both the true and false clauses first; if it gets a divide by zero on either clause, it will return #Error, even if that clause wouldn't have been used).</p>