Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Averaging in subsummary in FMP v 7

Averaging in subsummary in FMP v 7

Averaging in subsummary in FMP v 7

I have a report for my surgeries done over tha last 15 years. I get a total number of surgeries and the average per month in the Grand Heading. In the subsummary I get count of surgeries by month and year with sub-totals by year. I have tried to add a calculation to get an average of surgeries done by year and cannot get a formula to work.
Any help would be appreciated.

RE: Averaging in subsummary in FMP v 7

If you have your total surgeries by year or month in a calc field, make a unstored calc field using the GetSummary() function.

If you want your month average, make an unstored calc field using the Average() function on your month or year GetSummary() result field.

Put that field in a Sub-summary layout part (trailing or leading), sort by month for the month average and sort by year for the year average.

Show the preview of that layout to see the results.

RE: Averaging in subsummary in FMP v 7

Thanks for response - the total surgeries is derived as a summary using "count of surgeries" - should I change this to a calculation and if so, which formula should i use?

RE: Averaging in subsummary in FMP v 7

Well...yes and no.

I was rather thinking about a nice technique that Michael Edoshin used in his cross tab report.

You can read about it in:


If you put your years in a field, the sort of surgery as sub-category, you can make a very nice perpetual report of all your activities.

Give it a try.
Most developers will jump high and dry when I suggest to use repeating fields, but this is a technique I use for several years to generate reports, based on repeating fields, and it's working very well.


RE: Averaging in subsummary in FMP v 7

Further to this technique, if you have several pages in preview, it will be hard to scroll through the several records.

Here you can use a very nice technique from Ray Cologon, the floating palette.
You can download a sample file at:


If you make a combination from those two techniques your database will look like your surgeries, coooool.

Enjoy and happy filemaking.

If questions feel free...

RE: Averaging in subsummary in FMP v 7

I'm sorry to be so stupid about this. My report is set up to show a subsummary count of surgeries by month using summary field of "Count of Surgery" sorting by month and another subsummary showing Count of surgery by year. What I'm having trouble with is creating a calculation to sum the months per year and total years so I can the create the average per year compared to the average per year for the whole 20 years of surgery next to the total surgeries per year.
I'm not sure I'm explaining this well - but all I want to do is to get the average surgeries done per year over the whole time frame.

RE: Averaging in subsummary in FMP v 7

If you look at the technique from Edoshin (download file), then that would be the way to go, according to me.

It is very simple to implement that technique in an existing application with a minimum of overhead.

You can add as many as records as you want, the result will adapt for the whole period, even for your 20 years and even if you have 100 years.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close