7 Replies Latest reply on Dec 6, 2018 10:15 PM by Kelly Chua

    Syntax Error (Maybe you are missing an identifier)

    Kelly Chua

      Hi all,

       

      I'm new to calculated fields. Basically I have data on each employee test score which i like to format it red if below 50%, yellow between 75% and 95% and green for above 95%

       

      I am using the following calculation but ran into an error "Syntax Error (Maybe you are missing an identifier) which points to the red "THEN". 

       

      IF [Test Score] <=50%

      THEN "red"

       

      ELSEIF [Test Score] >75% and [Test Score] <90%

      THEN "yellow"

       

      ELSE "green"

       

      END

       

      Can anyone throw me a helpline?