AnsweredAssumed Answered

Baseball average (summary)

Question asked by user10801 on May 10, 2017
Latest reply on May 10, 2017 by bigtom

OK, I'm stuck on what I thought would be a fairly simple database of baseball stats.


This screenshot shows a detailed report.  Ultimately I will remove the body part to just show the summary fields.  They body is there for testing/viewing only.


All the TOTAL_AB, TOTAL_R, TOTAL_H, etc. fields are easy SUMMARY fields "total of AB" etc.


The TOTAL_AVG field is a calc though.  "TOTAL_H / TOTAL_AB".  That works for the line by line body but not the summary.


How can I create a summary field for the average?  I cannot use the average function because with that you can only point to one field?!



Hopefully I made the question clear.  I've probably just been looking FM for too long and missing something easy.  I hope someone can shed some light!!