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
OK, I'm starting to understand.  I think that the issue is that you need to count all the children but just the unique parents.

How about this for an idea.

Make a summary of the Minimum [Record ID#] of the child record.  Call it [Record ID# of 1st Child].

Look it up down to the children.

Then have a formula called [# unique Parents] 

IF([Record ID#] = [Record ID# of 1st Child],1,0)

Then summarize that field and each parent should only be counted once.