SELECT(salary exempt[EmpEmail], ([department] = “1153111”), TRUE)
how would I add OR department is 115310 in the above statement?
i want to send to all the salary exempt emails that are in those 2 departments
I guess you want to do this
SELECT(salary exempt[EmpEmail], OR([department] = “1153111”,[department] = “1153110”), TRUE)
Another alternative:
SELECT(salary exempt[EmpEmail], IN([department], {“1153111”, “1153110”}), TRUE)
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |