I am calculating % change on a report. The simple calculation below works just fine.
Occasionally there is a zero for the previous period and thus the % change is incalculable because we can't divide by zero. When that happens, the report shows ? for that line. I thought there must be a way to hide the question mark on the report. I've tried using the Hide Object when there is an evaluation error; but I'm not having success. I'm not sure the I'm using EvaluateError correctly.
Any ideas on hiding ? for percentages on lines that are dividing by zero? Thanks so much.