The Syntax ',' is incorrect

[M_SBS_6]

Hi, I am trying to create a new Quarter column based on the following log below, but seem to be getting the incorrect syntax to enbale this to work. I have tried mutliple things, but just can't work out how to resolve. 

quarter_financial_years = VAR __M = MONTH ( comp[comp_date] )
RETURN

if(isblank(comp[comp_date]), blank(),

if(comp[comp_fy_start_month_no] = 7,
__M IN {7,8,9} , "Q1",
__M IN {10,11,12} ,"Q2",
__M IN {1,2,3} , "Q3",
__M IN {4,5,6} , "Q4"),

if(comp[comp_fy_start_month_no] = 4,
__M IN {4,5,6} , "Q1",
__M IN {7,8,9} , "Q2",
__M IN {10,11,12} , "Q3",
__M IN {1,2,3} , "Q4"),

if(comp[comp_fy_start_month_no] = 10
__M IN {10,11,12} , "Q1",
__M IN {1,2,3} , "Q2",
__M IN {4,5,6} , "Q3",
__M IN {7,8,9} , "Q4") ))

[mangaus1111 · Accepted solution]

Hi @M_SBS_6 ,

delete these 2 commas

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@M_SBS_6 Try:

quarter_financial_years = 
VAR __M = MONTH ( comp[comp_date] )
RETURN 
SWITCH(TRUE(),
isblank(comp[comp_date]), blank(),
comp[comp_fy_start_month_no] = 7 && __M IN {7,8,9} , "Q1",
comp[comp_fy_start_month_no] = 7 && __M IN {10,11,12} ,"Q2",
comp[comp_fy_start_month_no] = 7 && __M IN {1,2,3} , "Q3",
comp[comp_fy_start_month_no] = 7 && __M IN {4,5,6} , "Q4"),

comp[comp_fy_start_month_no] = 4 && __M IN {4,5,6} , "Q1",
comp[comp_fy_start_month_no] = 4 && __M IN {7,8,9} , "Q2",
comp[comp_fy_start_month_no] = 4 && __M IN {10,11,12} , "Q3",
comp[comp_fy_start_month_no] = 4 && __M IN {1,2,3} , "Q4"),

comp[comp_fy_start_month_no] = 10 && __M IN {10,11,12} , "Q1",
comp[comp_fy_start_month_no] = 10 && __M IN {1,2,3} , "Q2",
comp[comp_fy_start_month_no] = 10 && __M IN {4,5,6} , "Q3",
comp[comp_fy_start_month_no] = 10 && __M IN {7,8,9} , "Q4"
)

[mangaus1111 · Accepted solution]

Hi @M_SBS_6 ,

delete these 2 commas

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.