How can I find the total unique IDs only in found set

[soulicious]

My problem: I can't find the total number of unique IDs when I do a find....

Some background:

I have a db tracking students. I have a portal to a related db tracking each student's total hours of tutoring each week. Not all students were tutored. Each tutoring subject is designated with a code. For example, english tutoring is 01, math is 02. Now I need to calculate the average number of hours students received tutoring per each subject (code).

I thought I was doing well when I set up my related db to find the number of unique IDs of students that actually received tutoring. Since each student had multiple entries in the portal, I set up a Calc field like this:

If(Min(Unique ID Self Join Relationship::Unique ID) = Unique ID,1,0)

This gives me a 1 for the first time that student is entered in the portal, but a 0 for other entires. Then I just took a Count of all the 1's to find the uniqueIDs entered.

This works great when I'm looking at ALL the students. I divide the total hours tutored by the total student count (of uniqueIDs actually receiving tutoring) to find the average. Cool! The problem is that when I do a find for, say, code 12 (computer tutoring), I don't get a true total count of students who received that. If they all already were input into the portal for math, my Calc field shows 0's for all of them, so my count summary is incorrect and I can't find the true average!

I hope this makes sense... Some help would be greatly appreciated. I'm attaching a zip of the relevant files if you want to check it out to make it more clear what the problem is.

[soulicious]

It seems there was a problem attaching in the previous post, so I'm going to try attaching the file again....

Thanks again for your help.

[color:"red"]For some reason I am getting a "Warning" and "CHMOD Warning" when trying to attach. It seems there is some configuration problems on the server for attaching. It looks like there are attachments, but they can't find anything... sorry. I'd be more than willing to e-mail the file if someone's willing to help...

[Lee Smith]

How big is the file?

There is alimit of 350000 in size and they must be either .zip or .sit.

HTH

Lee

[soulicious]

The file is only 289,000 bytes (289kb) in zipped format.

That's not the "Warning" I was getting. I made sure the file was small enough to be attached.

[Pupiweb]

I have a db tracking students. I have a portal to a related db tracking each student's total hours of tutoring each week. Not all students were tutored. Each tutoring subject is designated with a code. For example, english tutoring is 01, math is 02. Now I need to calculate the average number of hours students received tutoring per each subject (code)

Your best option IMO is to create a report in the Courses file, using subsummary parts to break it by student and by subject, using Summary fields to show the average number of hours per subject per student