Gender Percentage

[TennMan]

Can someone tell me if there is an easy way in FM v4 to calculate the percent of male (or female) members there are curerntly on a team?

There is a TEAM_NO field that is populated with a 4 character alpha-numeric code and a GENDER field that contains either a "M" or "F".

On a summary page where I can see the number of players on each team, I'd also like to see if I need to add males or females to balance the team, by see the percentage of one gender on the team.

In another language it would be something like -

(Count for GENDER="M") / (Count)

Thanks

[andygaunt]

OK,

You will need a couple of calculation fields.

For male team members

PatternCount(Gender, "M") / (PatternCount(Gender, "M") + PatternCount(Gender, "F"))

And for female members

PatternCount(Gender, "F") / (PatternCount(Gender, "M") + PatternCount(Gender, "F"))

Then, format the field to display 2 decimal places with a notation of percent