I'm writing a report that groups accounts by account name, and summing up a formula field that simply returns 1 for each account. Yes, I'm trying to find duplicate accounts.
I have a report that shows thousands of accounts with most of them showing a 1 for the count of duplicates. However, there are others with 2 or more in the group. Is there a way to filter out the 1's and only show records where the sum of 1's are greater than 1?
In SQL terms, this would be the equivalent to:
SELECT Name, Count(Id)
GROUP BY Name
HAVING Count(Id) > 1