Conditionals With More Two Or More Conditions

[Elena]

Hello there again,

 

In my calculated field, I am trying to write a condition that considers two or more variables to get to the resulting values. I have the following statement that when tested was invalid.

 

Thank you again for the help.

 

 

CASE

WHEN Charindex('Court',[@field:work_location])!=0 AND WHEN Charindex('Court',[@field:work_location])!=0 THEN 1163

ELES '0'

END

 

 

 

Thank you.

 

Elena

[Elena]

I wish to correct the statement as below:

 

CASE

WHEN Charindex('Court',[@field:work_location])!=0 AND WHEN Charindex('Monthly',[@field:work_location])!=0 THEN 1163

ELES '0'

END

[Jan]

Hello Elena,

 

If I understand correctly, after AND only a condition should be entered without WHEN.

And there is a misprint in ELSE.

I hope the code like following will work:

CASE
WHEN Charindex('Court',[@field:work_location])!=0 AND Charindex('Monthly',[@field:work_location])!=0 THEN 1163
ELSE '0'
END

[Elena]

Awesome! thank you, your recommendation works.  Also, thanks for catching the typo on my ELSE.