
1. Re: Calculation Help
philmodjunk May 16, 2013 7:16 AM (in response to tifmulally)Set up a calculation field, cCompleteFlag in Student_Course that returns a 1 if the course is completed and null or 0 if it is not. Then Sum ( student_courses::cCompleteFlag ) will return the number of completed courses and Count ( Student_Courses::Student_ID ) will return the number of such courses. If the sum = the count and the count is not 0, then the student's course work is complete.

2. Re: Calculation Help
tifmulally May 16, 2013 9:18 AM (in response to tifmulally)Thank you for your quick response. I am a bit confused on where the sum and count would be utilized... I have the calculation field set up in student_course would i set up separate fields for sum and count? Thanks again. 
3. Re: Calculation Help
philmodjunk May 17, 2013 9:51 AM (in response to tifmulally)The sum and count calculations have to be evaluated from the context of the student tableeither a calculation field defined in that table with the correct "context" selected or in script steps executed while a layout based on the student table is current or in a conditional format expression on a student layout.
Which method (or combination of them) is used depends on how you need to work with this data.
Please note that a single calculation can reference both the sum and count functions so you will not need separate calculation fields for each to show which students have completed all required courses.