Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have several case prefixes that I need to place in groups.
Case Types:
G
SA
BR
OR
MF
I need groupings:
Case Type | Group
G = Global
SA = TC/PC
BR = TC/PC
OR = TC/PC
MF = TC/PC
So that I have a QV field to choose either GLOBAL or TC/PC
Any help would be apprieciated.
Looks like you need this:
if([Case Type]='G', 'Global', 'TC/PC') as Group
Regards,
Michael
Look at MAPPING in the Help and Ref Guide.
-Rob
Hmmm... My previous post got lost for some reason.
Here is another suggestion:
Sinse you have only 2 possible values for Group field, you can use IF expression:
If([Case Type] = 'G', 'Global','TC/PC') as Group;
good luck!