condition formatting for a text control containing a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a text control in my report in which i want to calculate
percentage increase of revenue from year to year, so my formula would be
something like (revnue of year2/revenue of year1)-1.
Now I got #div/0! or #Num! for those that the formula gets to divide by 0.
Is there a way that I could set where the result is invalid to appear as N/A
or something more making sense? Thanks.
 
Try something like:

= IIf([revenue of year1] = 0, "N/A", ([revnue of year2]/[revenue of
year1])-1)
 
Back
Top