IIF Statement

[rpresberry]

I have an IIF Parameter in SSRS that is giving me an error and I can't figure out what's wrong with it. Any help would be great.

= iif(Parameters!pc.Value ="CAT","0",Fields!NonMOSales.Value)

 

[alow]

What's the error you're getting?

 

[rpresberry]

The error that I'm getting is "#Error"
there is no message, just giving me an #Error in th column.

Thank You

 

[alow]

Is the pc.Value field blank in the records that you're receiving this error? The IIF formula will return that if the field in the Expr argument is blank.