locked
SSRS IIF question RRS feed

  • Question

  • User1984700640 posted

    I have this expression on my report:

    =IIF(Mid(Fields!tradeindicator.Value, InStr(Fields!tradeindicator.Value,"/")+1, (InStr(Fields!tradeindicator.Value, ",") - InStr(Fields!tradeindicator.Value, "/") - 1)).Length = 0, "", Mid(Fields!tradeindicator.Value, InStr(Fields!tradeindicator.Value,"/")+1, (InStr(Fields!tradeindicator.Value, ",") - InStr(Fields!tradeindicator.Value, "/") - 1)))

    If a value exists between the "/" and the "," then it displays correctly.  But if no value, then #Error displays.  How do I not display #Error?
    Monday, December 1, 2014 1:07 PM

Answers