Having Trouble Getting a Percent off two numbers

[shifty]

(Sorry I am new to this and I think I did it right?) I have a Table with "Enrollment" and "Capacity" and I am trying to figure out the percentage of classes are closed? By closed I mean Enrollment = Capacity and then taking THAT number of closed classes divided by the total number of classes.

EDIT: Here it is if anyone cares or let me know if I should delete this post

SELECT SUM( IIF(PerceentOfClassesClosed = "Closed", 1.0, 0.0) ) / COUNT(1)


FROM (SELECT IIF((Class.Enrollment / Class.Capacity) = 1, "Closed", "Open") AS PerceentOfClassesClosed FROM Class)

[June7]

Combine how and what error?

Aggregate calcs are often easiest done on a report. Aggregate calcs are done in group or report header/footer textbox.

Did you mean to spell percent with 3 e's?

[shifty]

I did not lol but anyway I actually figured it out

Here it is if anyone cares or let me know if I should delete this post
SELECT SUM( IIF(PerceentOfClassesClosed = "Closed", 1.0, 0.0) ) / COUNT(1)
FROM (SELECT IIF((Class.Enrollment / Class.Capacity) = 1, "Closed", "Open") AS PerceentOfClassesClosed FROM Class)

[June7]

Glad you figured it out. Thanks for providing the solution. Was no need to edit the original post.