[RESOLVED] rdc Problem dividing

[DavidGraham167]

=iif(Fields!job_number.Value=0,"",Fields!job_number.Value/Fields!mast_jobno.Value)

I am dividing job_number by mast_jobno.
As this could give an error with a divide by zero, I'm using an iif statement to test for zero.
But I'm getting an error if I divide by zero.
What am I doing wrong?

[jggtz]

That's because IIF evaluates both, true & false expressions, before resolve
I would try an If Then Else

[DavidGraham167]

I coudn't find if then else.
I used a nested iif and it worked.
=IIf(Fields!mast_jobno.Value=0,"",Fields!job_number.Value/IIf(Fields!mast_jobno.Value=0,1,Fields!mast_jobno.Value))