How do I check for duplicates under a parent?

Jennifer Workman

Hello,

How could I check for duplicates (children) [Item Number] under a parent [123456]? Note: All parents will be a unique number value, but the Item Numbers will often be the same/repeat across the parents. I need this to check for duplicates under each parent.

L_123

This will currently check the column that it is in. If you want it to check a different column you need to put that column name in the children() with an @row reference. Example below

=if(count(Children([Column 1]@row))> count(distinct(children([Column 1]@row))),"Duplicate Submission")

L_123

=if(count(Children())> count(distinct(children())),"Duplicate Submission")

This should do what you asked. You can duplicate this with an or if you want to check more than one column, or just drag the formula across the parent row.

Jennifer Workman

How would I tell this what column to check under the parent?

L_123

This will currently check the column that it is in. If you want it to check a different column you need to put that column name in the children() with an @row reference. Example below

=if(count(Children([Column 1]@row))> count(distinct(children([Column 1]@row))),"Duplicate Submission")

Paul Newcome

@L@123

I like this solution! I wouldn't have thought to use the DISTINCT function for comparison like this.

L_123

@Paul Newcome Thanks, it's taken me a while to get used to the *new* formulas and really think about how dynamically they can be used, but i'm starting to feel comfortable with them. So long as my fingers don't type faster than my head and make small errors lol