1 Reply Latest reply on Aug 12, 2016 9:33 AM by Tom W

    Help with If Stmt. Syntax

    Ashe
    Ashe Aug 12, 2016 8:22 AM

      Hello Community,

       

      I could use some help with the following IF statement:

       

      IF [Period Month]= "1" OR "2" OR "3" THEN "Q1" ELSEIF [Period Month]= "4" OR "5" OR "6" THEN "Q2" ELSEIF [Period Month]= "7" OR "8" OR "9" THEN "Q3" ELSEIF [Period Month]= "10" OR "11" OR "12" THEN "Q4" END

       

      I'd like to create a calculated field that groups my months into a quarter value.