6 Replies Latest reply on Aug 17, 2016 10:23 AM by Dereck Melo

    Conditional Formatting

    Dereck Melo

      Hi Everyone,

      Hoping I have something simple.

       

      I've got a calculate field that looks like the below.. Basically normalizing point values come off a survey. I want to be able to these numbers some colors.

      IF [RAW POINTS]>=4.5 AND [RAW POINTS]<=5 THEN 100

      ELSEIF [RAW POINTS]>=3.4 AND [RAW POINTS]<=4.4 THEN 90

      ELSEIF [RAW POINTS]>=2.3 AND [RAW POINTS]<=3.3 THEN 80

      ELSEIF [RAW POINTS]>=1.2 AND [RAW POINTS]<=2.2 THEN 70

      ELSEIF [RAW POINTS]>=0 AND [RAW POINTS]<=1.1 THEN 60

      ELSE 0 END

       

      I've done another calculated field that looks like this but it's not working when I put this field into color. What am I doing wrong?

      IF AVG([NORMALIZED POINTS])>=60 AND AVG([NORMALIZED POINTS])<=69 THEN 'RED'

      ELSEIF AVG([NORMALIZED POINTS])>=70 AND AVG([NORMALIZED POINTS])<=79 THEN 'Yellow'

      ELSEIF AVG([NORMALIZED POINTS])>=80 AND AVG([NORMALIZED POINTS])<=89 THEN 'Orange'

      ELSEIF AVG([NORMALIZED POINTS])>=90 AND AVG([NORMALIZED POINTS])<=99 THEN 'Grey'

      ELSEIF AVG([NORMALIZED POINTS])=100 THEN 'Gold'

      END

       

      thank you

      Dereck