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.

I understand (and have used many times) the usual method as posted all over StackOverflow for avoiding division by zero error in SSRS:

```
=IIF(Fields!A.Value=0,0,Fields!B.Value-Fields!A.Value/IIF(Fields!A.Value=0,1,Fields!A.Value))

```

However in this case the usual method is insufficient. Consider the following:

```
 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%

```

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!