Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing dupped amounts 1

Status
Not open for further replies.

bnsSteve

Technical User
May 3, 2010
94
CA
Hi there,

Sorry this has been posted a lot, couldn't find one that I could use as a template.

Need to sum up $value on only one record which are duplicated.
Ex:
Group1 - (Transit) ABC
Group2 - (App#) 123
Detail
(App#)123 - (Transit) ABC - $1,000
(App#)123 - (Transit) ABC - $1,000
(App#)123 - (Transit) ABC - $1,000
Group2 - (App#) 890
(App#)890 - (Transit) ABC - $2,000
(App#)890 - (Transit) ABC - $2,000
(App#)890 - (Transit) ABC - $2,000

Need to show a sum at the group 1 level but not summing up the duplicate records. I.e, Group 1 for ABC value should = $3,000 (App890 + App123) not $9,000.

I think it may have something to do with runningtotals?

Thanks for your help, much appreciated.

Running Crystal 11 - 14.0.2.364
 
Insert a running total that sums amount, evaluates on change of group #2, reset on change of group #1. Place it in the group #1 footer only.

-LB
 
Thanks LB works great! Was originally resetting on change of field.

Running Crystal 11 - 14.0.2.364
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top