Formula results in #Error sometimes, how to replace those?

[ppataki]

Dear All,

I have a formula in a field of a query like:
A/B (A and B are both expressions)

In some cases A or B or both are 0, in that case the formula results in #Error
I tried Iserror(A/B) but still I get the #Error result instead of a True/False result...

Could you please advise how I can replace the #Error with 0 or null value?

Many thanks in advance

 

[Atomic Shrimp]

if it's a divide by zero problem, I'm surprised it's not falling over altogether.

You could try
Iif(B<>0, A/B,0)