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.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!