9 Replies Latest reply on Apr 30, 2018 12:06 PM by Okechukwu Ossai

    Help with a Case State,emt

    Karen Schaefer

      What am I doing wrong in the following Case Statement?

       

      CASE IFNULL([COSTS],0) THEN '*'

              WHEN [COSTS] < 1    THEN 'Red'

              WHEN [COSTS] >1     AND [COSTS] <= 2.79 THEN 'Yellow'

              WHEN [COSTS] >2.79  AND [COSTS] <= 3.79 THEN 'Bronze'

              WHEN [COSTS] >3.79  AND [COSTS] <= 3.79 THEN 'Silver'

              ELSE 'Gold'

           END   

       

      Thanks,

       

      K