#Error in IIF formula

Question

I am using report builder and I have created an IIF statement on a calculated field I have created (called Tolerance)

The field of "Tolerance" is returning a difference in time between two other fields in the format of 00:00:00.

My IIF statement is as follows:

=IIF(Fields!Tolerance.Value < = "-00:10:00", "Passed","Failed")

This is running OK in the report but the results are all #Error.

Thanks for your suggestion, but doing what you have suggested has made no improvement and is returning the same error — Shaun Williamson, Apr 22 '15 at 11:29

score 1 · Answer 1 · answered Apr 22 '15 at 11:16

1

You have an space between < and =. This space is not allowed, as these are not two different operators, but a single <= operator:

=IIF(Fields!Tolerance.Value <= "-00:10:00", "Passed","Failed")

answered Apr 22 '15 at 11:16

Mureinik

297,002
52
306
350

Thanks for your suggestion, but doing what you have suggested has made no improvement and is returning the same error – Shaun Williamson Apr 23 '15 at 08:20

score 0 · Answer 2 · answered Apr 29 '15 at 07:22

Is your field Tolerance.Value a number?

Value "-00:10:00" is a string.

Try

=IIF(CSTR(Fields!Tolerance.Value) <= "-00:10:00", "Passed","Failed")

It would be helpful if you would provide samples of your Tolerance.Value values. This solution might only fix the #Error in your resulting report, but not be what you want in case Tolerance.Value should be formatted to similar format with your "-00:10:00" value.

#Error in IIF formula

2 Answers2