#Num! in Report

[Fisher]

I am having trouble with report values returning as #Num!
I have two text boxes that display caluculations based on the number of true values in yes/no fields:
=(Sum(IIf([Eligible]=True,1,0))) which is text 8 and
=(Sum(IIf([Eligible]=True,1,0))) which is text 10.
I then want to divide text 10 by text 8.
I have tried the Nz function as below and many other combinations but can't seem to eliminate the #Num!
=Nz([Text10]/[Text8],0)
Any help would be appreciated.
Thanks

 

[Rich]

Well you can't divide by zero and the contol formulas you've posted are both the same

 

[Fisher]

Sorry.
It should have read:

=(Sum(IIf([Eligible]=True,1,0))) which is text 8 and
=(Sum(IIf([Enrolled]=True,1,0))) which is text 10.
I then want to divide text 10 by text 8.

 

[selenau837]

Sorry.
It should have read:

=(Sum(IIf([Eligible]=True,1,0))) which is text 8 and
=(Sum(IIf([Enrolled]=True,1,0))) which is text 10.
I then want to divide text 10 by text 8.

I see you want to divide text 10 by 8, however if text 8 is ever 0 and text 10 is not, then you will get that error. You can't divide by 0.

 

[Fisher]

Thanks for replying.
Is there not some way that I can have the response display blank or something other than the error?

 

[selenau837]

Thanks for replying.
Is there not some way that I can have the response display blank or something other than the error?

Yes, something like

=(Sum(IIf([Eligible]=True,1,""))) which is text 8 and
=(Sum(IIf([Enrolled]=True,1,""))) which is text 10.

Then when you go to divide those two text boxes, you need to do an IF statment to determin if box 8 is "", if it is don't divide, and if it isn't then divide.

Make sense?