Forum Discussion
The Syntax ',' is incorrect
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") ))
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.
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" )
2 Replies
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.
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" )