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
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