Compare Descendent Row Data

michael.chefer
Contributor

Compare Descendent Row Data

 

What's the recommended function/formula combination to compare the Period and Final Amount data in order to identify duplicates? Note: The items being compared are in a composite list and share a parent. I would only want to compare items that roll-up to the same parent.  

 

In this example I want to flag any rows with the same Period and same Final Amounts. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jasonblinn
Master Anaplanner/Community Boss

Re: Compare Descendent Row Data

The first thing that comes to my mind would be to concatenate Parent ID & Period & Final Amount, and then use ISFIRSTOCCURRENCE to see if there are not the first occurrence (Or conversely, say NOT ISFIRSTOCCURRENCE to flag the items that are duplicates)

 

Jason

View solution in original post

1 REPLY 1
jasonblinn
Master Anaplanner/Community Boss

Re: Compare Descendent Row Data

The first thing that comes to my mind would be to concatenate Parent ID & Period & Final Amount, and then use ISFIRSTOCCURRENCE to see if there are not the first occurrence (Or conversely, say NOT ISFIRSTOCCURRENCE to flag the items that are duplicates)

 

Jason

View solution in original post