Specific Average

[dharkin]

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

[comment]

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.

[dharkin]

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

[comment]

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.

[dharkin]

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

[comment]

Something like this?

Averagex2.fp7.zip

[dharkin]

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

[comment]

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.

[dharkin]

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.

[Ender]

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

[dharkin]

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

[comment]

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.

[dharkin]

Thanks for all of your help.

DH