Summerize Sub-Summerized values from Child Records based on groups

Question

Howdy all.&nbsp; Does anyone know any tricks to accomplish the following as seen in the attached image?&nbsp; The child records to this parent come in sets of 3, each one has a field called "Run-Time".&nbsp; I need to combined the run-time of a set of 3 child records, then I need to summarize those totals up to the parent.&nbsp; This would give me an average run time per group of 3.

------------------------------John Ross------------------------------

lordsmanburgos · Answer

I'm assuming these fields are numeric, in which case you could create a new field for every triplet and then Sum() the values:

Field ChildSum_n+1:
Sum([Child 1], [Child 2], [Child 3])

Then you can just summarize the ChildSum_n+1 results in a new field:

Average([ChildSum_0], [ChildSum_1], [ChildSum_2], ...)

Makes sense?

------------------------------
Lordsman Burgos
------------------------------

Makes sense?------------------------------Lordsman Burgos------------------------------

johnross1 · Answer

Hey Lordsman
When you say to create a new field for every triplet, do you mean the child records?&nbsp; They could be dozens to hundreds of them so tons of fields doesn't sound like a good idea... haha.&nbsp; Or, did I misunderstand?------------------------------John Ross------------------------------

markshnier__you · Answer

You say that the child records come in sets of three. Are those sets labeled in anyway like

Set 1
Set 2
Set 3

how would you know which children belong to which subset?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

johnross1 · Answer

Hey Mark, thanks for the reply.
Ah sorry I forgot to specify that.&nbsp; Originally I was going to write the RID of the first record of the triplet set into all 3 records with a field called "Group".&nbsp; So I can identify them, but that's where I became stuck.&nbsp; I'm open to changing this if needed.
------------------------------John Ross------------------------------

markshnier__you · Answer

Are you saying that each triplet member shares a field with the same numeric value?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Summerize Sub-Summerized values from Child Records based on groups