on 05-28-2015 4:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.