G
Guest
I have records as follows
Course# Title CRN Enrollmen
266 History of Theater 12345 20
266 +Discussion 12346 2
266 +Discussion 12347 2
266 +Discussion 12348 5
As you can see, the sum of the discussion classes equal the enrollment for the main class "History of Theater". There are about 20 courses out of a list of 200 that that have discussion groups. When I create the report, I group by Course#. In the sum of the group enrollment, I want it to only put in the Enrollment for the History of Theater, eliminating the discussion enrollment. I still need to see the discussion enrollment, I just don't want it calculated in the total, because it would be twice the actual enrollment for the course.
I have tried converting the number to a string when the title = "discussion", I have tried summing when title <> to "Discussion". Neither works. The report sum function insists on adding all the enrollments for the group.
Any suggestion
Course# Title CRN Enrollmen
266 History of Theater 12345 20
266 +Discussion 12346 2
266 +Discussion 12347 2
266 +Discussion 12348 5
As you can see, the sum of the discussion classes equal the enrollment for the main class "History of Theater". There are about 20 courses out of a list of 200 that that have discussion groups. When I create the report, I group by Course#. In the sum of the group enrollment, I want it to only put in the Enrollment for the History of Theater, eliminating the discussion enrollment. I still need to see the discussion enrollment, I just don't want it calculated in the total, because it would be twice the actual enrollment for the course.
I have tried converting the number to a string when the title = "discussion", I have tried summing when title <> to "Discussion". Neither works. The report sum function insists on adding all the enrollments for the group.
Any suggestion