Wrong syntax

Question & Answer
,
1

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)
2

Hi @anasia

first at the last sum there is a “)” missing.

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
                )
            )
        )
    )
)

But what is the error telling?

1 Like
3

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!