I have a main report that calculates a percentage from a value on a sub report. I am getting these three errors in different records. "#Div/0!" and "#Num!" and "#error".
I understand that what they mean:
divide by zero error
zero divided by zero error
and a number divided by a record that doesn't exist.
How can I catch all three errors? I have searched and found different things to try but nothing so far has caught all three errors.
My subreport field is called CatTotal or subyear_varianceactual.CatTotal.
The formula I have in the percentage text box (txtdollarvariance) now is:
I think I need a couple of "or ifs" in there but I am getting all confused.
Thanks in advance,