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.

Hi,

the Hide Object condition would be

Not GetSummary(

the one in the denominator)p.s. you can make this more efficient by changing your calculation to use the Let statement and the "" (empty string).

Let(

den = GetSummary(

the one in the denominator);If ( den > 0 ;

the numerator/ den ;"" )

)