AnsweredAssumed Answered

COUNT calculation field

Question asked by CourtneyGreen on Jan 11, 2012
Latest reply on Jan 12, 2012 by philmodjunk

Title

COUNT calculation field

Post

I am working on layouts/reports where I can see how many EVENTS each STUDENT attended. Right now, I have a calculation field in the STUDENTS table for COUNT(GrantParticipation::OpportunityID). However, this field displays all of the opportunities (funding, tutoring, learningop, events etc) that students attended and not just EVENTS.

Where do I have to put a field, and what does the script say that will allow me to count only the EVENTS attended by each student? 

 

Thanks in advance for your help!!

Screen_Shot_of_Database.gif

Outcomes