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