Skip to Content
0
Former Member
May 11, 2008 at 08:05 AM

Sum duplicate values in crystal reports XI

441 Views

Post Author: Stuart

CA Forum: Formula

Hi All

As you probably know I'm very new to crystal reports.

Apologies but it seems my previous question was unclear as no one has been able to respond.

What I need is a formula that can recognise a name in field1 is a duplicate and then the amount in field2 for both rows should be sum together thus creating only one row with the same name in field1 but with the two values sum in field2.

I've had a look around and I can see how to remove the duplicates but I want to sum the duplicates into one row not two or three, etc.

Hope to hear from you,

Kind Regards,

Stuart