Link to home
Avatar of Isaac
IsaacFlag for United States of America

asked on

Duplicate values in SP List

Hello All,

I have a list as seen below.  I need to add up the “Projected Amount” column but I don’t want to add up duplicates.  I just need to add the value once for each "Program Name".  When it comes to CAML query, there is no 'DISTINCT' keyword to use to get distinct "Program Name" as in my example.

So, using the example below, I would be adding as follows:
3080+300371+1090210

User generated image
My list has about 80,000+ items with duplicates throughout.
Avatar of leakim971
leakim971
Flag of Guadeloupe image

From Google :

{Link to competing site deleted by COBOLdinosaur, Topic Advisor}

http://tipsinsharepoint.wordpress.com/2010/06/24/3-level-cascading-dropdowns-in-sharepoint-remove-duplicate-records/
Avatar of Isaac

ASKER

I found those links yesterday.

I found the following solution today and it worked great.

{ Link to competing site removed by COBOLdinosaur, Topic Advisor}
ASKER CERTIFIED SOLUTION
Avatar of Isaac
Isaac
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
nice, close and accept your own answer
Avatar of Isaac

ASKER

Found solution on my own.