Formatting percents w/no value in report

[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!

 

[Marshall Barton]

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)

 

[Elizabeth]

Would that be the box where the calculation is?

Thanks!

 

[Elizabeth]

Thanks, it worked!!!

-----Original Message-----



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

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