Skip to Content
avatar image
Former Member

Grouping question

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    May 28, 2015 at 04:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • May 28, 2015 at 04:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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