Overflow Error: Character Limit in Control Source?

[wscott]

The following calculation is giving me an overflow error. Is it possible that my calculation has too many characters? I have tried everything I can think of but nothing works.

 
=Sum(((IIf([goal],1,0))+(IIf([report1],1,0))+(IIf([report2],1,0))+(IIf([report3],1,0))+(IIf([report4],1,0))+(IIf([report5],1,0))+(IIf([report6],1,0)))/((IIf([participantName],1,0))*([ParticipationDue])))

[pbaldy]

Dividing by zero can produce that error, and it looks like your formula could result in that happening. Can it?

[wscott]

I checked all of the data, and even added a field with each element of the denominator, and dividing by zero is not the issue.

[wscott]

I don't understand why placing all of the code in one control source will not work. However, I already had the numerator and denominator displayed in separate fields, so I just referenced those by name in a third control (and hid them in the footer.)

[pbaldy]

Thanks for posting the solution; it may help someone down the line.