5 Replies Latest reply on May 10, 2017 1:41 PM by bigtom

    Baseball average (summary)

    user10801

      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!!