Syntax error while calculating fields using ifelse()

Question & Answer
, ,
1

Hi all,
need your help for the following stated issue.

I have given the following if else expression in the calculated field for creating controls using parameters,
ifelse(${Dimension}=‘org_id’,{org_id_id},${Dimension}=‘patient age’,{patient_age},{assesement_status})
but it shows the syntax of the calculated field is incorrect. I have checked and compared with the syntax and some examples from documentation. I guess my expression is correct, can anyone let me know what Iam missing or what is the error in my expression?
Any suggestions would be greatly appreciated!

Thank You!

2

Use IN function with Ifelse.

ifelse( IN([‘org_id’],${Dimension}),{org_id_id},
IN([‘patient_age’],${Dimension}),{patient_age},
{assesement_status})

Try Something Like this.

3 Likes