cancel
Showing results for 
Search instead for 
Did you mean: 

Grouping question

Former Member
0 Kudos

I have a need to create a grouping based a keyword within a field.  The field in my report is Defect.Short_Description.  The short description contains a brief subject of what the defect is related to.  In some instances, it may contain the word Rollout.

What I need to do is be able to group the Rollout items separate from the non-Rollout ones. Is this possible?

Thanks

Glen

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Glen,

Create a formula with this code:

If instr({string field}, 'Rollout') > 0 then

'Rollout'

Else

'Non Rollout'

You can then insert a group off of this formula field via the Group Expert or the Insert Group option.

-Abhilash

Former Member
0 Kudos

Thanks to Dell Stinnett-Christy and Abhilash Kumar for responding at almost the same time. Your tip worked like charm.  Wish I could mark both as Correct Answer.

Glen Rogers

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

Yes.  You would create something like the following formula:

If InStr(UpperCase({Defect.Short_Description}), 'ROLLOUT') > 0 then 'Rollout' else 'Non-Rollout'

Then create a group on this formula.

-Dell

Former Member
0 Kudos

Thanks to Dell Stinnett-Christy and Abhilash Kumar who responded almost at the same time!  You tip worked like a charm. Wish I could mark both as a correct answer

Glen Rogers