Compare Descendent Row Data

Highlighted
Certified Master Anaplanner

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 REPLY 1
Highlighted
Certified Master Anaplanner

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