Discussions

Expand all | Collapse all

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

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

    Posted 12-12-2018 20:03
    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_.



  • 2.  RE: Need the total of one field to show as a value in another field

    Posted 12-12-2018 21:17
    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.




  • 3.  RE: Need the total of one field to show as a value in another field

    Posted 12-12-2018 21:40
    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]


  • 4.  RE: Need the total of one field to show as a value in another field

    Posted 12-12-2018 21:44
    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.


  • 5.  RE: Need the total of one field to show as a value in another field

    Posted 12-13-2018 16:21
    Thanks for the suggestion Mark that helped me out a lot