Calculation Based On Unique Names

[adyf]

This should be an easy one for someone hopefully. I am looking for a calculation that will count the number of unique names that meet a single criteria.

Unique because there are several records that have the same name in the name field and I only want this to be counted once. The criteria I want to set is the persons grade, therefore this calculation would give me the number of people I have working in each grade.

Unfortunately I only have FM6 which doesn't have some of the functions available in later versions.

[bcooney]

How about a subsummary by name, with no body part and a summary field in the subsummary, Count (keyField).

[comment]

??

[bcooney]

Alright, I deserved that, comment. The OP's structure is so bad, and he's in FM6, that I just did one off the top of my head.

I do think that a sub-summary by name will get him there.

He really should have a join table btw People and Grades.

[comment]

I don't see how a join table would help in counting the number of students in the found set (of the join table).

Besides, a relationship between People and Grades is hardly a many-to-many (unless you consider {A; B; C; D; F} to be an entity).

The solution can be found here:

http://fmforums.com/forum/showpost.php?post/135493/

[bcooney]

What students? I saw it more as Teachers and Grades. Many teachers/many Grades. It's an assignment of teachers to grades, I think, not a grade book.

Edited June 8, 2009 by Guest

[comment]

OK, I have re-read the OP and decided I don't get it. :)