I need to write a formula in a report to calculate positive outcomes. We have 4 statuses that represent a positive outcome: Adopted, Match/Matching, Placed, Reunified with Bio Parent. For each summary year, I need to calculate the percentage of the total kids that had a positive outcome for each year. I've tried all sorts of formulas and cannot seem to get this to calculate. I would appreciate any suggestions you can give me. Thank you!
My report looks like this:
I'm trying to reconstruct an Excel spreadsheet that looks like this:
답변 9개
