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

5 Replies

Related Content

Calculate total days with a condition...

Adding totals across multiple database entries ?

Percentages are Sums instead of Averages on the Total and Averages Rows

When Field Value has been changed Make another field Required?

Using summary totals in another report

Recent Discussions

Empower Hour Tomorrow!

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Rollup Help

New Forms Return and Cancel Buttons Glitch

How to handle error in Upload step in Pipeline