I have a database of applicants and three views that allow reviewers to rate them from ⭐ to ⭐⭐⭐⭐⭐. I want to create a formula field that captures their average rating. I can use .length() but I'm wondering if there are other approaches that might work.
Not everyone has rated every applicant so 0 stars doesn't mean that the applicant is a zero, just that the reviewer hasn't gotten to them yet. I'm also not sure how to account for that.
