on 07-25-2017 9:02 PM
-- Someone can please help me to solve this issue, Thanks in advance.--
I have scenario like this where "COL_NAME" Contains "(Major|Global|Named|Regional|Territory) (Account|Accounts|Sales) (Manager|Mgr))" then "YES" else "NO". This I want to create in Calculated field
This has to be work combination like if the column contains values like : Major Account Manager
Major Accounts Manager
Major Sales Manager
Major Account Mgr
Major Sales Mgr
Next --------------
Global Account Manager
Global Accounts Manager
Global Sales Manager .......etc
It has to work all the combinations as like given examples above. Please suggest me if it is there any relevant function which works.
Hi Ramana,
You can try the case function while creating the expression in calculated column.
case("ROLE", 'Major Account Manager', 'Yes', 'Major Accounts Manager', 'Yes', 'Major Account Mgr', 'Yes', 'Major Sales Manager', 'Yes', 'Global Account Manager', 'Yes', 'Global Accounts Manager', 'Yes', 'Global Accounts Mgr', 'Yes', 'Global Account Mgr', 'Yes', 'Global Sales Manager', 'Yes', 'NO')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.