Group based on a formula in Crystal Reports

[angel7170]

Hello,

How to create a formula and then Group using it.
The data I have is

2414 - Detroit West
2437 - Columbus Suburban
------------------------
2542 - Eau Claire
2543 - Lexington

I want to group these two based on the first two charaters of the string.
for ex; say I want to group by "24 series", 25 series etc
Please assist.
Thank you so much

 

[IanWaterman]

Create formula using left

eg

@Series

left(IDField, 2)

Then group on this

Ian

 

[angel7170]

Awesome! Works perfectly. Thank you