What are the return values for the Icon function?  The Help section seem to indicate that it returns a string but doesn't say what the string is.  I want to use the value in an If statement in another field.

Example:  I have a field called "MBR Status" that uses the “3colorcircles” option to show if the status on the most recent MBR was red, yellow, or green.  I’d like to have another field that is called "At Risk" that is Yes if the MBR Status is either yellow or red, and No if it is green.  So my thinking was something like this:

The backing table has a field called "MBR" that is populated with either "green", "yellow", or "red".

On the report, the field that uses the icons looks like this:

MBR Status = Icon("3colorcircles",MBR="green",MBR="yellow",MBR="red")

The "At Risk" field would look at the "MBR Status" field and evaluate to either No(if green) or Yes (if not green):

At Risk = If(MBR Status="green","No","Yes")

But this doesn't work because the Icon function doesn't return the values I'm thinking in would (i.e. "green", "yellow", or "red".)  So what does Icon return?

The values returned are:

<img src='images/scorecard/small_green.png'>

<img src='images/scorecard/small_red.png'>

<img src='images/scorecard/small_yellow.png'>

An example of a column checking the value:

At Risk = If(MBR Status="<img src='images/scorecard/small_green.png'>", "No", "Yes")

Thanks to @Chris Davidson for his help on this!

Thanks Diane!  This works great.

One little follow up... I actually didn't specify this in my question, but I am using the "<div align='center'>" in my MBR Status field, so that the icon shows up center-aligned instead if left-aligned.

So, MBR Status = "<div align='center'>"&Icon("3colorcircles",MBR="green",MBR="yellow",MBR="red").

I found that you also have to include this in the At Risk formula.

At Risk = If(MBR Status="<div align='center'><img src='images/scorecard/small_green.png'>","No","Yes").