Dear Colleagues,
I would like to know how to have SWITCH with Multiple Expected Values for the Same Expect Result please?
I have the following expression from the Data Table Provile for “Are Updates Allowed?”:
Standard:
SWITCH(USEREMAIL(),
“user1@mydomain.com”, “UPDATES_ONLY”,
“user2@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)
I want to make it like this, where the Expected Resulit of “ALL_CHANGES” has multiple email addresses:
SWITCH(USEREMAIL(),
(OR “user1@mydomain.com”, “user2@mydomain.com”), “ALL_CHANGES”,
“READ_ONLY”)
The above does not work, so what is the correct expression to allow different email addresses to have “ALL_CHANGES”?
Thanks.
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |