Jump to content

Count how many records with certain value


OnTheOutside
 Share

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.