4 Replies Latest reply: May 9, 2011 1:50 PM by Stefan Walther RSS

    Problem with if statement

      Hello,

       

      I am trying to do a nested if.  The field I am evaluating can either be a number or text.  These are lab results.  The text part is when the lab enters a result like - '>15'.  If it is this, then I'm trying to put in a "1" into my flag field.  The statement is not even recognizing this part of my if statement and I can't figure out why.  Here's my statement:

       

      if(num([Event Tag]) > 6, 1,

           if(text([Event Tag]) = '>15*', 1, 0))     as INR_Flag6

       

      The first part will evaluate correctly, but the second part won't.  Any suggestions will be greatly appreciated!  I've tried everything I can think of to get this to work.

       

      Thanks,

      nmellick