How can I display a symbol based on a text value?

[bnichol]

I have a set of standard symbols my company uses for status levels.... Green circle (good), Red x (bad).

Is there a simple way to display these in a text box based on a text value?

Can this be used to display the symbol in a column of a straight table?

Thanks,

B

[IAMDV]

Hi B,

I think the simplest way is to use Wingding or similar font, which produces the symbol you needed. Then use the character is the IF statement to validate the value in the text.

Let me know, if this helps!

[#3]

I have a text box which is an image of say... a radioactive sign and in the presentation tab (I think it is) under show it's conditionally set to display only when sales are lower than a certain amount. I don't know your situation enough to say but if you need different status levels based on a dimension that won't really help you.

[rwunderlich]

In your text box use a conditional expression and point to the image file - either external or bundled. And then set the Representaion property fot the text box to "image". For example:

=if(sum(Sales) < 1000,
'qmem://<bundled>/BuiltIn/check_g.png',
'qmem://<bundled>/BuiltIn/cross_r.png'
)