create a group based on the text in the item description 1

[blueboyz]

I am using Quantum 2013 by Sage. Pervasive SQL is the database engine and using Crystal 2008.

I need to group items on the report by the Item Description. The Item Description has text then a slash "/" and then more text.
I want to group on the Item Description for all the text before the slash.

Here's how I want the report to look:
ITEM ID ITEM DESCRIPTION
M59505/15 RACING FORK FLUID 15WT/5 GAL
TOTAL FOR RACING FORK FLUID 15WT

M59901/5 RACING FORK FLUID 5WT/1 LTR
M59505/5 RACING FORK FLUID 5WT/5 GAL
TOTAL FOR RACING FORK FLUID 5WT

M59901/7 RACING FORK FLUID 7WT/1 LTR
M59505/7 RACING FORK FLUID 7WT/5 GAL
M59055/7 RACING FORK FLUID 7WT/55 GAL
TOTAL FOR RACING FORK FLUID 7WT

M58505L RACING SHOCK – LT 3WT/32 OZ
M58505L RACING SHOCK – LT 3WT/5 GAL
TOTAL FOR RACING SHOCK – LT 3WT

M58901M RACING SHOCK – MED 7WT/32 OZ
M58505M RACING SHOCK – MED 7WT/5 GAL
TOTAL FOR RACING SHOCK – MED 7WT
TOTAL FOR COST OF GOODS SOLD ACCOUNT 43100

How can I create a formula based on the text before the slash in the Item Description so I can then group on the formula?

 

[briangriffin]

The split function creates an array for you to isolate individual elements:

split({ItemDescription},"/")[1]

 

[blueboyz]

Will the split function create the different groups for the like Item Descriptions?

 

[AndyMc]

Looks like you'd group on:

split({ItemDescription},"/")[2]

 

[blueboyz]

Awesome! Creating a group on split({ItemDescription},"/")[1] did the trick.

Thank you so much!