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

    Problem with if statement



      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.