Forum Discussion

JohnRoss1's avatar
JohnRoss1
Qrew Member
3 years ago

Summerize Sub-Summerized values from Child Records based on groups

Howdy all.  Does anyone know any tricks to accomplish the following as seen in the attached image?  The child records to this parent come in sets of 3, each one has a field called "Run-Time".  I need...
LordsmanBurgos's avatar
LordsmanBurgos
Qrew Trainee
3 years ago

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
------------------------------