Reply to comment

re: Using "Greater than" in a case statement

Hi Nick --

The Case statement requires all the arguments to have the same field type. 

If you created a Formula-Text field to hold the formula and clicked the "Allow HTML" checkbox, then constructed the statement with an If() instead, like so, it should work:

 

If([Total Score]>0.8,"<img src=https://lpl.quickbase.com/up/bf9dhw8cy/g/rf/ej/va/greenbutton_g.png>",
[Total Score]<0.5,"<img src=https://lpl.quickbase.com/up/bf9dhw8cy/g/rd/ej/va/redbutton_r.png>", 
"<img src=https://lpl.quickbase.com/up/bf9dhw8cy/g/re/ej/va/yellowbutton_y.png>"

 

Regards,

--S.

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit