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

Question

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

quickbasecoachd · Answer

It's a little hard to see the detail in that screen shot.&nbsp; Can you give me an example with numbers of the calculation.&nbsp; Just give an example with 3 "rows" of data.

tylerparker · Answer

Sorry I thought everyone could click the image to enlarge to full sizeName&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Event Count&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Event TotalEmployee 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 165Employee 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 165Employee 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 165Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;165The [Event Total] field is what I'm seeking to fill from the summed values in [Event Count]

quickbasecoachd · Answer

You would need to have a parent record for the event in a relationship where 1 Event has Many employees.&nbsp; Then on that relationship it will let you make a summary field.&nbsp; Then look up that summary event total back down to the child records.

tylerparker · Answer

Thanks for the suggestion Mark that helped me out a lot

jengwata · Answer

Forum Discussion

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

Related Content

Copy Single Table from One App to Another

Consolidate Field Types

Total Formula with 2 IF statements

How to copy a user to another user field in a webhook?

Incrementing a field values based off another field's content.