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 to combined the run-time of a set of 3 child records, then I need to summarize those totals up to the parent. This would give me an average run time per group of 3.
------------------------------
John Ross
------------------------------
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?
+24You 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?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
