Crystal-How To Write "In List" Formula

[twkyoscr]

Looking for simple way to do the following:

@Category =
if jobcode = 1063, 1009 1008 etc (about 18 job codes) then "Certified Nursing Tech"

I would like to avoid writing separte if then statements and just do if in list then else. Thanks!

 

[vidru]

Try this:

@Category =
if jobcode in [1063, 1009, 1008, ...] then "Certified Nursing Tech"

-dave

 

[twkyoscr]

Thanks for your response, that is just what I'm needing. I entered the following and I am getting an error message

if {A_CNT_01_STAFFINGMIX.JOBCODE} in ["001062","001009","001043",...]

The error message says that the ] bracket is missing and it places the cursor in the middle of the list of job codes. Any thoughts?

 

[twkyoscr]

Never mind, I was missing a quote on a job code listed. THANKS AGAIN!

 

[vidru]

Try using single quotes instead of double quotes.

-dave