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.
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)