AnsweredAssumed Answered

Hide ? on Layout When Dividing by Zero

Question asked by greengk2fi on Sep 12, 2016
Latest reply on Sep 18, 2016 by greengk2fi

I am calculating % change on a report. The simple calculation below works just fine.


Screen Shot 2016-09-12 at 12.34.24 PM.png


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.

Screen Shot 2016-09-12 at 12.43.18 PM.png


Any ideas on hiding ? for percentages on lines that are dividing by zero?  Thanks so much.