3 Replies Latest reply on May 30, 2013 12:04 PM by Kyle B

    Case statement not working for new calculation field

    Ravi kumar

      i have an requirement , i need to create status column with buttons ( like in shapes) based on some existing columns based on some conditions. i wrote case statement but its not working.

       

      here is my case statement

       

      case when [savings %]  < -5 then "RED"

              when  [savings %] >= -4.99  AND [savings] <= 4.99 then "YELLOW"

               when [savings %] > 5 then "GREEN"

      end.

       

      here [savings %] is existing column.new column name is status