IIF Statement

R

rpresberry

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL IIF statement with TOP 10 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Access My Expression Contains Wrong number of arguments 0
IIF Function in Update Query HELP! please :) 0
Multi IF expression not displaying all the data 4
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
multiple IIf statement doesn't work - please help 0
Calculated field producing possible 4 different results 1

Back
Top