You need to sign in to do that
Don't have an account?
CraigH
Total of grouped field in report
Does anybody know how I can total a count of the summarized groups in a report.
i.e. Say I have an object model like
Parent object
Child object (look up relationship to parent)
and Data like
Parent 1
Child A
Child B
Parent 2
Child C
Child D
Parent 3
I then do a report based on the Child object and group by the lookup field to parent
Using recordCount, I can get the total # of records on the report (i.e. 4)
What I would like is to see the total of all Parent objects (with children) - in the example above 2
Okay, in that case you can just use your custom field on the parent object and sum it in the report. FK_Contact.MyIncrementer__c:SUM
All Answers
If I understand correctly, you would be looking for field containing "7" based on your example.
This is just one solution I am sure, but you can create a custom formula field on your parent object that simply holds a value of 1. Then in your report, you can create a formula field on the Grand Summary level which adds the RowCount and the custom field:
RowCount + FK_Contact.MyIncrementer__c:SUM
Hi
Actually I just want 2 (the # of parent objects with at least 1 child)
Okay, in that case you can just use your custom field on the parent object and sum it in the report. FK_Contact.MyIncrementer__c:SUM