Counting based on a field entry

[SoomoTom]

Hi,

I have a table that is a list of members of organizations. Each record is a unique member but some are from the same organization.

I want to count the number of users per organization. My optimal solution would be to have a field with a total number of entries from that org.

Can I do that with FM? In excel I use the 'count if' function.

Thanks,

Tom

[mr_vodka]

This is similar to this thread from this morning.

http://www.fmforums.com/forum/showtopic.php?tid/201268

You can use a summary field that counts. Group and sort by the organization field.