Formatting percents w/no value in report

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

Elizabeth

I have a report that shows the percent of monthx out of a
yearx. However, in one year, year x = 0, so each month is
also zero. 0/0 is an undefined number. How would I
change the report so that in the space where error is
shown could I show something else, like text?

Thanks!
 
Elizabeth said:
I have a report that shows the percent of monthx out of a
yearx. However, in one year, year x = 0, so each month is
also zero. 0/0 is an undefined number. How would I
change the report so that in the space where error is
shown could I show something else, like text?


You can test for that in a text box's expression:

=IIf(yearx = 0, "N/A", monthx / yearx)
 
Back
Top