Need to Use Result of One Column in Formula for Next Column

Content

Hello there Reporting and Analytics experts.  I am hoping one of you can help me out with an analysis I am working on.

I am trying to get our FTE reports up and going so that I can tell where we are at for each of our departments in terms of number of staff per provider.  I can easily run this report for the entire organization by taking the FTE count divided by our total number of providers in the organization.  Where I run into issues is when the data needs to be specific to each department.  Each department has their own providers, and some don't have providers at all.  So the calculation will be different for each department.