formula syntax

[SamLN]

Hi smart people!

I cant quite get the syntax of the following formula correct. I want to say
if {PERSON.PERSON_POSITION} = 'Law Clerk' and {PERSON.EMPLOYEE_NO} is not either '252' OR '296' OR '336' then "LC" else "XX"

seems really simple but just cant get it to work.
I tried - if {PERSON.PERSON_POSITION} = 'Law Clerk' and {PERSON.EMPLOYEE_NO} <> in ['252','296','336'] then "LC" else "XX"

Sam

 

[pmax9999]

Try:

If 	{PERSON.PERSON_POSITION} = 'Law Clerk' and 
	Not({PERSON.EMPLOYEE_NO} in ['252','296','336'])
Then 	'LC' 
Else 	'XX'

Cheers
Pete

 

[SamLN]

Thank You that worked