NOT function when used in a range/array CR 8.5

[wayneCl]

CR 8.5

what im trying to do is make a formula where the following is true


NOT emp.div in ["mtk", "DB", "FD"] and Not EMP.ID in [1000,2000,3000]

now can do emp.div <> &quot;mtk&quot; but that will take to long as there are many more keys


is it possible or is the a better way on solving this


thanks for your help

 

[lbass]

The syntax for record selection would be:

not ({emp.div} in [&quot;mtk&quot;, &quot;DB&quot;, &quot;FD&quot;]) and
not ({emp.id} in [1000,2000,3000])

-LB

 

[wayneCl]

Thanks for your help