Pls Help- format undefined numbers

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

Elizabeth

I posted this earlier today but I am not sure if my title
made sense. I have generated a report that shows a
percent contribution of the month ton the whole year
total. For one of the years, there was no activity ina
certain category so the percent was 0/0 = undefined
number. It displays on the form as some error
like : "#Num!" How do I get this to display either text
or zero?

THANKS!!!!
 
You might try changing calculation to something like:
=iif(denom=0,0,numer/denom)

That way, if the denominator is 0, you don't try to do the
division, you just display 0.
 
I'll try it---thanks!
-----Original Message-----
You might try changing calculation to something like:
=iif(denom=0,0,numer/denom)

That way, if the denominator is 0, you don't try to do the
division, you just display 0.

.
 
Thanks!~ It Worked!!!
-----Original Message-----
You might try changing calculation to something like:
=iif(denom=0,0,numer/denom)

That way, if the denominator is 0, you don't try to do the
division, you just display 0.

.
 
Back
Top