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)) asINR_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.