I manage enrollments at a private academy

I'm simply trying to display the results of a simple equation which is the total max capacity of enrollments minus current enrollments.

the result of this equation will give me how many available slots i have to enroll before max capacity.

Any quick solutions to this?

You can set up a relationship that matches only to students with "enrolled" in that text field. Count ( RelatedTable::FIeld ) can return that count.

ExecuteSQL can also be used to return a count.

Is this over all students and you are showing remaining capacity for a school or do you also need to limit this by a specific course or scheduled course?

The principals are the same, the details differ.