I would like to update the formula below to include any records where the Job Title is "Director" in addition to the "Manager" job title which is included below. I am not sure what the correct syntax would be to include the "Director".
IF
contains([Job Family Group],"Sales")
AND
contains([Job Title],"Manager")
THEN 'false'
ELSE 'true' ENDIF
Solved! Go to Solution.
Hi,
you can try:
IF
contains([Job Family Group],"Sales")
AND
contains([Job Title],"Manager") OR contains([Job Title],"Director")
THEN 'false'
ELSE 'true' ENDIF
there is also formula IN but i dont have access to Alteryx now to Check it.
with it you could replace this part:
contains([Job Title],"Manager") OR contains([Job Title],"Director")
Thank you - that worked!