Hi Everyone,
I want to create a report to show all Accounts and their related contact but the report should include only the Accounts that have more than 1 related contact.
One of the solution is to create a roll-up field that counts the no of related contact to account.
But this solution is currently not feasible for me. Is there any other way to include only the account that have more than 1 contact without creating a extra field.
Unfortunately you can't filter a Report by the results of the Report.
You also cannot use a Report SUMMARY Formula as a Report filter, you can only do that with a Report ROW-LEVEL Formula. But a Row-Level Formula can't perform the mathematic operation that you're trying to perform (Sum the number of Contacts per Account)
For that you'd need to use a Flow or custom Code, or something like Declarative Roll-Up Summary (DLRS) by Andy Fawcett (it's free)
https://andyinthecloud.com/2020/04/05/declarative-rollup-summary-tool-update/
or an App like Roll-Up Helper (there's a freemium version on the AppExchange).
https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000009i3UpEAI
