how to alias a group name

[Former Member]

I Have a col that is the highest level group. The twist is that, if the col has actual data that starts with 'GROUP' e.g. Group1, Group9; this means

it is the Trophy department.

For the report. i have that col as the first group level. i have to total each group1,9 for another row, for that; but the actual name displayed should be 'Trophy' whereas I would never know if Group9 is the last actual data. maybe there was no group9 so i can't convert that way.

[DellSC · Accepted solution]

If I understand you correctly, the field you're grouping on has many values, only some of which start with the word "GROUP".  You want to group all of the "GROUP" values together at the highest level with a name of "Trophy".  Is that correct?

If so, try grouping on a formula that looks something like this:

If UpperCase(Left({MyTable.GroupField}, 5)) = "GROUP" then "Trophy"

else {MyTable.GroupField}

-Dell

[Former Member · Accepted solution]

Thanks Dell, yes that is the point. When the col has a value that starts with 'GROUP'

this means the order was a 'Trophy order'. the report is summarizing the main departments, which includes Trophy.

[Former Member · Accepted solution]

this is showing the each group, like GROUP1. GROUP9 not saying trophy

[abhilash_kumar · Accepted solution]

Try:

If Instr({MyTable.GroupField}, "Group") > 0 then "Trophy"

else {MyTable.GroupField}

Use this formula field as the Group #1 in the Group Expert.

-Abhilash

[former_member205840 · Accepted solution]

Hi Paul,

You can also try below formula :

if {GroupName} startswith 'GROUP' then 'Trophy' else {GroupName}

-Sastry