Simple error in calculated field for a parameter

I’m constructing a simple parameter with a two-choice dynamic field and when creating the calculated field for the parameter it throws a syntax error, like this:

ifelse(${Dimension}=‘Title’,{TitleName},${Dimension}=‘Employee’,{Employeeid},{JobName})

It just tells me that there’s a syntax error but I don’t know how to fix it

Hi @Edgar_Rodriguez
is the parameter single or multi value?
BR

1 Like

Hi @Edgar_Rodriguez

I think EmployeeID is integer and other fields are strings that could be one reason for the syntax error. Could you please try using tostring to convert employeeid to string and use it in the expression .

ifelse(${Dimension}=‘Title’,{TitleName},${Dimension}=‘Employee’,tostring({Employeeid}),{JobName})

Thanks
VInod

1 Like

Hi ErikG
Its multi value

I did it but the syntax error persists and points out that it is at the beginning ifelse(${Dimension}

HI @Edgar_Rodriguez
if the parameter is multi value QS cant compare with “=”.
BR

1 Like

Ok, I understand Many thanks.