June 2, 2014 at 12:55 am
Hi, trying to write a condition that evaluates a parameter value and then, depending on that parameter value tests another condition with true/false. I know the below statement isn´t entirely correct but I´m not familiar with writing nested IIf statements.
=IIf(Parameters!LTI.Value <> "All LTI"), IIf(Fields!payReceive.Value <> First(Fields!payReceive.Value, "Liability"), "TRUE", "FALSE")
Update: Think I got it, should be something like:
=IIf(Parameters!LTI.Value <> "All LTI", IIf(Fields!payReceive.Value <> First(Fields!payReceive.Value, "Liability"), "TRUE", "FALSE"), "")
June 2, 2014 at 4:57 am
The second one seems fine to me.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply