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"



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