Summing Rows with Substring'd Field 1

[Hawkmek]

Ahhh . . . My first time. . . posting that is.
Wanna say right off the bat I am a novice Crystal user.
You may wanna "dumb it down" for me.

Here's the current report output:
Dept ID Fund Amount
E3400 566 5.00
E3400 566 1.00

Here's the desired output. We want to sum amount if Dept ID AND Fund are the same:

Dept ID Fund Amount
E3400 566 6.00

Now the catch is that the Fund is the middle 3 digits of a unique number, i.e. Row 1 is really 55566BIO,
and Row 2 is really 45566BIO. So the query pulls two rows and the substring is two rows and how the Hell do I combine them?

Hope that's enough info. If not, let me know.
I'll check back in on Monday.

Thank you for taking a look.

Hawkmek

 

[lbass]

You can create a formula:

{table.deptID} + mid({table.fund},3,3)

Insert a group on this formula and then you can right click on the amount field and insert a summary at this group level. Then drag the deptID field and the formula just for fund into the group footer and suppress the detail section.

-LB

 

[Hawkmek]

Finally was able to put lbass' solution to the test.
Thank you so much for the help. It worked like a charm!
Maybe this Crystal thing is not so hard after all. After reading your reply, I was like, "Okay, how do I do this, how do I do that?" I figured it out though.
I will definitely stop by here again in the future when I get stuck.
I use another forum for help with Excel. And now I have speedy tech help available for Crystal as well.

Thanks again LB!

Hawkmek