I get a syntax error on this expression and I don’t understand what is wrong, can someone help?
ifelse(
${Tidperiod}='Dag' AND {project_category}='External' AND {Actual date} >= ${igar} AND {Actual date} <= ${idag},sum({working hours}),
${Tidperiod}='Vecka' AND {project_category}='External' AND {Actual date}>=${veckaborja} AND {Actual date}>=${veckaslut},sum({working hours}),
${Tidperiod}='Månad' AND {project_category}='External' AND {Actual date}>=${manadborja} AND {Actual date}>=${manadslut},sum({working hours}),
${Tidperiod}='Kvartal' AND {project_category}='External' AND {Actual date} >= ${kvartalborja} AND {Actual date} <= ${kvartalslut},sum({working hours}),
${Periodstarting}='År' AND {project_category}='External' AND {Actual date} >= ${kvartalborja} AND {Actual date} <= ${kvartalslut},sum({working hours}
,NULL)
second I think there are a few ifelse missing, too. maybe this will work?
ifelse(${Tidperiod}='Dag' AND {project_category}='External' AND {Actual date} >= ${igar} AND {Actual date} <= ${idag},sum({working hours}),
ifelse(${Tidperiod}='Vecka' AND {project_category}='External' AND {Actual date}>=${veckaborja} AND {Actual date}>=${veckaslut},sum({working hours}),
ifelse(${Tidperiod}='Månad' AND {project_category}='External' AND {Actual date}>=${manadborja} AND {Actual date}>=${manadslut},sum({working hours}),
ifelse(${Tidperiod}='Kvartal' AND {project_category}='External' AND {Actual date} >= ${kvartalborja} AND {Actual date} <= ${kvartalslut},sum({working hours}),
ifelse(${Periodstarting}='År' AND {project_category}='External' AND {Actual date} >= ${kvartalborja} AND {Actual date} <= ${kvartalslut},sum({working hours}),NULL
)
)
)
)
)
The error was: ‘The syntax of the calculated field expression is incorrect. Correct the syntax and choose Create again.’ it wasn’t the parenthesis (that was my copy-paste mistake). I think it was something wrong with the spacing because it worked the way you wrote it. Thanks!