Are you wanting something like this?
I don't think that you need to have 6 separate formulas to split Instructional and Non-Instructional since Tableau is able to determine the level of detail in your view.
I made a new Participation Rate calculation, which is simply:
[Response Count]/[Staff Count]
Let me know if I'm missing something.
Participation Rate.twbx 15.7 KB