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.
You cannot structure the or like that. You need to do
IF [Period Month] = "1" OR [Period Month] = "2" and so on..
Become a Viz Whiz on the Forums! Support the Community and master Tableau.