title: RDLC expression resulting in #error
body: <p>I have two decimal fields, profit and revenue.  They are displayed in a tablix control, each has their own column.  In a third column, I want to divide profit by revenue.  The result when either of those fields is zero is #error, this I'm guessing is due to the dividing by zero.  I came up with the following expression to solve this:</p>
  
  <pre><code>=iif(Cint(Fields!revenue.Value) = 0 orelse cint(Fields!profit.Value) = 0 ,"",FormatPercent(Fields!profit.Value / Fields!revenue.Value,2))
  </code></pre>
  
  <p>That expression still results in #error.  I did some testing and took out the false portion of the expression.  The expression looked like this:</p>
  
  <pre><code>=iif(Cint(Fields!revenue.Value) = 0 orelse cint(Fields!profit.Value) = 0 ,"No","Divide")
  </code></pre>
  
  <p>When running that expression, the original spots that had #error, now show "No".  That tells me that expression is working like I would expect, but why does it throw the #error when I add the division in the false condition.  It should not be hitting that part of the expression.  Any help is appreciated.  I also tried a switch statement but the results were the same.  It threw the #error anytime I had the division in the expression.</p>