Reply to comment

Using "Greater than" in a case statement

I am trying to use a case statement with a "greater than" option.  Basically if my Total Score field is greater than 80% I want to show a Green label.  If between 50%-80% show a Yellow label, and then if it is less than 50% show a Red label.  Quickbase isn't allowing me to use the > and < symbols.  Below is the code it isnt accepting.  Any help?

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

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