Skip to main content
Question

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

  • December 13, 2018
  • 0 replies
  • 88 views
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_.

    This topic has been closed for replies.

    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.


    • TylerParker
    • Author
    • Registered
    • December 13, 2018
    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]
    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.
    • TylerParker
    • Author
    • Registered
    • December 13, 2018
    Thanks for the suggestion Mark that helped me out a lot
    Terms & ConditionsAccessibility statement