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.
Help Article Resources
Categories
Check out the Formula Handbook template!
