Need the total of one field to show as a value in another field

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I'm trying to have the totals from the Hard Acceleration/Hard Braking/Speeding/Idling fields show up as the value in separate fields in the same table. I started with the Hard Acceleration Total field to illustrate. Can anyone help here?

The end goal is a weighted average formula. I've made a parent table but when I make summary fields to show the average of the entire field, it only averages the field per driver, not the entire field.

Photo of Tyler Parker

Tyler Parker

  • 850 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,478 Points 50k badge 2x thumb
It's a little hard to see the detail in that screen shot.  Can you give me an example with numbers of the calculation.  Just give an example with 3 "rows" of data.


Photo of Tyler Parker

Tyler Parker

  • 850 Points 500 badge 2x thumb
Sorry I thought everyone could click the image to enlarge to full size

Name                         Event Count             Event Total
Employee 1                  50                                  165
Employee 2                  60                                  165
Employee 3                  55                                  165

Total                             165


The [Event Total] field is what I'm seeking to fill from the summed values in [Event Count]
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,478 Points 50k badge 2x thumb
You would need to have a parent record for the event in a relationship where 1 Event has Many employees.  Then on that relationship it will let you make a summary field.  Then look up that summary event total back down to the child records.
Photo of Tyler Parker

Tyler Parker

  • 850 Points 500 badge 2x thumb
Thanks for the suggestion Mark that helped me out a lot