Grouping Values from a field

[#1]

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.

[Anonymous]

Looks like you need this:

if([Case Type]='G', 'Global', 'TC/PC') as Group

Regards,

Michael

[rwunderlich]

Look at MAPPING in the Help and Ref Guide.

-Rob

[bgerchikov]

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!