IIF Statement

Joined
Oct 11, 2012
Messages
2
Reaction score
0
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.
:confused:
= iif(Parameters!pc.Value ="CAT","0",Fields!NonMOSales.Value)
 
The error that I'm getting is "#Error"
there is no message, just giving me an #Error in th column.

Thank You
 
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.
 
Back
Top