I Need help with formula to prevent AVG Parent percentage from rolling up.

Julie Browning

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.

Julie Browning

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!

Julie Browning

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!

Genevieve P.

Hi @Julie Browning

I'm glad you were able to figure it out! Thanks for posting your solution.