Conditional Formating

[sspainhour]

I would really appreciate any help. I have a filed that list the type of insurance a person has (Type). I have another field that lists the total coverage (Total). In a report I would like the Total field to only be displayed if the Type is not a Health policy. I thought this would be a fairly simple formula, but I keep getting an error. Below is the formula I used:
=IIf(([Type]="Health")," ",[Total])
If the type field = health it does display nothing. But if the type field does not equal health, it displays error#. I substituted the type field in place of the total field and it worked perfectly. Can someone please help. Also, I am not sure if it matters, but the type field is a text field and the total field is currency.

 

[sspainhour]

I finally figured it out. The total field was defined in a query, not set up in a table, so I just redefined the field in the report and it worked fine.