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.

Find more posts tagged with

Formulas

Accepted answers

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!

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.