Hello,

I have database of students listing their scores on various tests.

I would like to create a field to supply me with the average score for males on a specific test.

I am using a summary field but I am getting the average of all students for a specific test.

Your help is appreciated

DH

Why don't you add a sub-summary part (when sorted by gender) to the layout, and place your summary field in it.

You could also do a find for a specific test AND specific gender, but I think that might get tedious very quickly.

Thanks for the response. I think I would like it to be more dynamic. Meaning when a new entry is made the field would update immediately. Instead of having to perform a sort or find in order to see the result. Is there a way to have FMP sort the subsummary automatically without effecting the whole db.

Thanks for your help.

DH

Is there a way to have FMP sort the subsummary automatically without effecting the whole db.

No. You only see sub-summaries in Preview mode, after sorting. Perhaps you could do something else: define a calculation field that returns the score if the student is male. Then summarize this field separately.

This might be suitable for a very small number of sub-totals; if you need more sub-categories, consider aggregating over filtered relationships.

Perhaps you could do something else: define a calculation field that returns the score if the student is male.

This is what I am trying to do in one field, but I can't get Males and Females to average seperately. It is driving me crazy. I can get it to work in excel using "daverage" but no luck in FMP

Something like this?

Averagex2.fp7.zip

Hello

Thanks for interacting with this calculation I am having.

But I am trying to keep it to one calculation.

This is what I have so far but I cannot get it to keep it to a specific gender in the calculation.

If (StudentGenderlu="M" ;Average ( SaxonJune))

*Saxon June is the type of test given in that month

But I am trying to keep it to one calculation.

I don't think you can, at least not with your version (with 8 Advanced and up, you could do this with a custom recursive function).

I suggest you read the help on the Average() function to understand why your attempt won't work.

I should have updated my profile, sorry.

I am using 8.5 advanced.

Is there a way to achieve this using 8.5?

Thanks for all of your help and time.

DH

I don't think you can, at least not with your version (with 8 Advanced and up, you could do this with a custom recursive function).

I suggest you read the help on the Average() function to understand why your attempt won't work.

You can update your profile in the Control Panel under the My Profile tab at the top. Go to the FileMaker Questions section.

You can update your profile in the Control Panel under the My Profile tab at the top. Go to the FileMaker Questions section.

Thank You

I am using 8.5 advanced.

Is there a way to achieve this using 8.5?

Yes, as I said you could this with a custom function, but... it would not be the easiest function to write, and it would be quite slow compared to a summary field. How slow depends on how many records are there in the found set.

Thanks for all of your help.

DH