Forum Discussion

Hongkunliang's avatar
Hongkunliang
Qrew Cadet
8 years ago

How to get the count of parent record in child table?

I create a summary report in a child table.  I'd like to have the total count for the parent record in the summary report too.   However, there's no intrinsic way to do this.  Any one has some suggest...
App builders
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
If you edit the relationship, you can make a summary field for the count of the # of children.  Then look that up down to the child records. 

Include that field in your summary report, but use a function of Average rather than Total so as not to multiply duplicate the total and just count it once, hence an average of all the identical values.