Identifying Duplicates, sum numbers associated with duplicates

I'm working with the data below to identify duplicates based on the "full part number" and want to sum all "part rates" associated with those "full part numbers".

Example: for 7L14-1040-AA0028, each row would should say "94.44%". I want to keep duplicates in the file.

How can I recognize duplicates, not remove them, and then sum the "part rate" for all of the duplicate parts without summing an entire column?

Workflow

Help

Accepted answers

All comments

apathetichell

unique tool can get you only unique values - you can branch off- unique and then use a summarize.

You'll also need to change your percentages into doubles via multi-field formula with a nifty

tonumber(replace([part rate],"%","")) and change the type to double.

sswift13

I understand that I can separate them, do two different formulas, and then join them back together, but how would I write a formula to sum the "take rate" of all matching "full part numbers"?

apathetichell

Sorry - here's what I get when I use a summarize and rejoin strategy with the data you uploaded. Is this close to what you want?

group sum.yxmd

atcodedog05

I guess i forgot on the rejoining part @apathetichell 😅

Hi @sswift13

Here is a variation to the above joining approach. I am using find & replace tool which works like excel vlook up.

Hope this helps 🙂

part number.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703