Percentage Inaccurate for Simple Calculation
Hello all,
I was brought in to help with this formula on another sheet. I took care of the formula, but it doesn't seem to be accurate. They want to calculate the percentage of the one error @row out of the total errors. There 10 total errors right now, which allows for some nice easy math. However, when I calculate 1 out of 10 errors, I am getting 11%, not 10.
What is going on here?
My formula is: =(Counts@row / (COUNT($Counts$1:$Counts$9)))
Deena Duran, MA (She/Her)
🌟 Smartsheet Overachiever, Mobilizer, and Early Adopter 🌟
🎓️ Core App, Project Management, and System Administrator Certified 🏅
Senior Business Analyst
University of New Mexico Health Sciences
Best Answer

Hi @Deena Duran
Using count in the formula counts non blank cells (including the zeros) not the values of the cells as part of the sum so its actually basing the sum off of 9 rows not 10 events.
Try this instead
=(Counts@row / (SUM($Counts$1:$Counts$9)))
Hope that helps
Thanks
Paul
*Edited for clarity
Answers

Hi @Deena Duran
Using count in the formula counts non blank cells (including the zeros) not the values of the cells as part of the sum so its actually basing the sum off of 9 rows not 10 events.
Try this instead
=(Counts@row / (SUM($Counts$1:$Counts$9)))
Hope that helps
Thanks
Paul
*Edited for clarity

Thank you, @Paul McGuinness! That formula worked perfectly! Thank you for the explanation as well. This will help me with future formulas
Deena Duran, MA (She/Her)
🌟 Smartsheet Overachiever, Mobilizer, and Early Adopter 🌟
🎓️ Core App, Project Management, and System Administrator Certified 🏅
Senior Business Analyst
University of New Mexico Health Sciences

Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!