Greetings,

I need to have statistical calc field which can count up the number of records that have a certain value in a specific field.

Example:

field= Student::ethnic

possible values= asian, caucasian, black, hispanic

I need another calc field which will total each of the different choices in the found set (Student::Cstat_ethnic). Can you help with the If/Case statement to make this work?

I have several other fields to do the same with, but if I get one working then they should all work to create dynamic stats on the found set.

Thanks in advance.

This thread has a good discussion of how to count or sum values using a subsummary report. There are other techniques discussed but subsummaries are the most flexible.

http://fmforums.com/forum/showtopic.php?tid/176284/post/206543/hl/subsummary+John+Mark+Osborne/#206543

Thanks, but a subsummary report does not provide statistics on several different fields in the same report. I need things like:

-"how many ethnic students and how many of each"

AND

-"how many military applicants & which branch"

AND

-"how many economically disadvantaged students applied"

AND

-"How many of what type of visa"

AND

etc., etc.

The subsummary reporting seems to me to require a separate report for each item you need stats on. Is this wrong?