Error message

[CoachPhil]

I have a Division by Zero error when I run a report. I believe I have traced it back to a query, an expression in the query ‘ACHT: Nz(AgentDataByMonth!t_logged_in/AgentDataByMonth!n_incoming,0)’ returns an 'Error' on lines where there are zeroes in the calculation.
Am I on the right track?

CoachPhil

 

[georgedwilkinson]

Typically this type of error occurs when a field in the denominator of a formula evaluates to zero (0). You can eliminate the error by evaluating it away, like this:

Iif(Nz(MyFieldInTheDenominator,0)=0,"",MyNumerator/MyFieldIndTheDenominator)

 

[CoachPhil]

as always, you are on the mark, thank you George

 

[georgedwilkinson]

Always glad to help.