title: Need SSRS Expression for Percent of Change that avoids division by zero error
body: <p>I have a field in my report that shows the percentage of difference between two other columns A and B. Columns A and B are integer values and can each be positive, negative, or zero. I need to be able to provide a positive, negative, or zero % change based on the difference between A and B.</p>
  
  <p>I understand (and have used many times) the usual method as posted all over StackOverflow for avoiding division by zero error in SSRS:</p>
  
  <pre><code>=IIF(Fields!A.Value=0,0,Fields!B.Value-Fields!A.Value/IIF(Fields!A.Value=0,1,Fields!A.Value))
  </code></pre>
  
  <p>However in this case the usual method is insufficient. Consider the following:</p>
  
  <pre><code> A   |   B   |   Diff   |   % Change        |  % Change
                           (By Usual Method)   (As I need to see it)
   2   |   3   |    1     |     50%           |     50%
  -1   |   2   |    3     |     -300%         |     300%
   0   |   0   |    0     |     0%            |     0%
   0   |   3   |    3     |     0%            |     100%
   0   |  -3   |   -3     |     0%            |    -100%
  </code></pre>
  
  <p>I need an expression that will avoid the divide by zero error, but I cannot simply replace the error message with 0%. Any help the community can provide would be greatly appreciated!</p>