7 Replies Latest reply: Oct 17, 2011 1:03 PM by Kiran Rokkam RSS

    Help with Visual Cues Expression

      Hi,

       

      I am trying to use green, yellow, and red visual cues for a specific field. I need it to result as green when my field: Cont_Type is a certain number. The only thing I can get it to result back in is the normal field yellow.

       

      This is what I have:

       

      =if(left(Cont_Type,4)='40-H',66.99,if(left(Cont_Type,2)='20',26.99,if(left(Cont_Type,2)='40',56.99,if(left(Cont_Type,2)='45',76.99,if(left(Cont_Type,2)='53',100.99,)))))

       

      I am not sure why this field will not return the correct coloring of green.

       

      Any input would be greatly appreciated!

       

      Thanks