I Need help with formula to prevent AVG Parent percentage from rolling up.
I have several (18 rows to be exact) rows that I am need to get the AVG percentage for. 17 of the rows are currently at 100% and 1 row is at at 92% (because there is one step still left to complete before it can be at 100%). When I do the formula AVG "Children", it wants to round up the percentage to 100% (the actual answer is 99.5555....) I want it to be realistic. We are not actually at 100% so I do not want to report it as such, i would like it to report as 99%. I looked at the ROUND formulas but am not understanding how that works for a PARENT row. I am formula challenged as it is. :)
Thank you for any assistance.
Best Answer

So I figured it out. It was actually not a formula issue but rather as simple as using the Increase decimal icon on the tool bar. Hope this helps other newbies out!
Answers

So I figured it out. It was actually not a formula issue but rather as simple as using the Increase decimal icon on the tool bar. Hope this helps other newbies out!

I'm glad you were able to figure it out! Thanks for posting your solution.
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
Check out the Formula Handbook template!