#Error

Topic

New Reply

I have a report with the query created within the report. I have several calculation fields. One of which divides the number of clients by different worker classifications. On some days there are no worker within a classification so the math is 47/0. This gives me the #Error in the field. How do I prevent this or convert to a value of 0? Thank you. Fay

Reply | Quote

Replies

Try:
=iif([classifications]=0,0,[clients]/[classifications])

edited to add closing parenthesis

Reply | Quote

Thank you that did the job. Fay

Try:
=iif([classifications]=0,0,[clients]/[classifications])

edited to add closing parenthesis

Reply | Quote