Joined: 08 Nov 2012
Online Status: Offline
Posts: 2
Topic: combine multiple values into one new name Posted: 08 Nov 2012 at 4:26pm
I'm looking for some assistance in combining multiple values to display with a new name of my choosing. for example: Values are MC - test MC - release MC - Production and i want to display this group as "Main Campus".
This is only my second week using Crystal and appreciate any pointers!
Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Posted: 09 Nov 2012 at 2:46am
When you said, combining multiple value, means do you like to concatenate multiple fields to show as one field/column? What do you mean by group here? Please explain a bit more..
Joined: 08 Nov 2012
Online Status: Offline
Posts: 2
Posted: 09 Nov 2012 at 3:24am
Let me rephrase. I would like to group everything that starts with "MC" into a single group named "Main Campus". I am looking to do a total count by campus instead of per workstation location.
Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Posted: 09 Nov 2012 at 4:55am
Report -> GroupExpert-> Add Field which you wanted to Group->Options-> Options Right Tab->Check Customize group name Field-> check Radio Button (Use Formula as Group Name)->Click [X-2] ->Write formula similar to: IF {field} STARTSWITH "MC" THEN 'Main Campus' ELSE {field} Then Count accordingly. If this is not the case, you have to create a formula similar to the above and group by on that formula and count Group By.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum