title: SSRS - IIF error in Report Builder
body: <p>I am having an issue with a divide by zero error that I have half way worked through.</p>
  
  <p>Basically I need (EstimatedValuePlanned - EAC) / EstimatedValuePlanned</p>
  
  <p>I have the following, however I am still getting #Error on some:</p>
  
  <pre><code>= IIF (Fields!EstimatedValuePlanned.Value = 0 , 0, 
  Fields!EstimatedValuePlanned.Value - Fields!EAC.Value) 
  / 
  SUM(Fields!EstimatedValuePlanned.Value)
  </code></pre>
  
  <p>I have changed the code around several times but I still either get Error or NaN </p>
  
  <p>Thank you</p>