Using conditional loop in calculated field JWT

simarpreet singh

Hi team,

I have created a number calculated field by JWT. Under math expression, I want to add a condition that when the option is yes for field A, this calculated field is set to 1, if the option is No, then this is set to 0. Else, nothing should happen.

I'm able to do this for yes and No. But not able to restrict it for other dropdown option which is None. I know I can remove None by making field A as mandatory and setting a default option, but I don't want to make that change.

Is there anyway to achieve this.

Thanks,

Simar

 

Thorsten Letschert _Decadis AG_

Hi @simarpreet singh ,

given your field A with the field code 12345, your expression could look like this:

%{12345} = "yes" ? 1 : (%{12345} = "no" ? 0 : null)

Please let me know if that solves your requirement.

Cheers
Thorsten