Hello all. Im having issues in a report with a text box returning #Num. I have found its because of the values are 0 on one or more of the fields on the caculation. How do you work around this? =([Text475]+[Text485])/[Text455]
Hello all. Im having issues in a report with a text box returning #Num. I have found its because of the values are 0 on one or more of the fields on the caculation. How do you work around this? =([Text475]+[Text485])/[Text455]
Use an IIf() and test the cryptically-named Text455 and return 0 if it's 0.
How would you write that?
Why don't you give it a go and we'll fix it if you can't get it right?
I think I got it... Thank you !! =IIf([text455]=0,0,([Text475]+[Text485])/[Text455])
Happy to help!