How to get record count of parent object and remove duplicate child record counts in a report
|Knowledge Article Number||000005730|
In reports of type 'parent-object with child-objects', e.g. accounts with opportunities, you may face a challenge to get the record count of the parent object, be it lookup or master-detail. Since the record count gives the total number of child object records. This can be overcome using a workaround which involves the creation of a formula field.
Create a custom formula field on each object which is part of the report type.
Now add this Field to a report and summarize(sum) the field to get the count of parent records in the report. You can also use it to get average, percent, etc.