Unable to get an avg percentage for some depends for a report

I created a summary report that shows percentages for each task under high-level management. The issue that I am having is when I summarize the percentage column using average. The high-level manager does have a percentage, instead has a NaN.

The percentage column is an IF OR statement using quotes to hold the percentage.

I removed the quotes and percentages to see if I could use the number result and the percent format. But my 100s turned into 10,000% and my 50s turned into 500%. Now I am stuck and trying to figure out what to do to get my summary report to show percentage instead of NaN. Thank you for your response!

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Nick Korna

Hi @JerryLouis,

If you're wanting to use percentages instead of text, they operate on a 0-1 scale. For example, if you wanted 50% to be the result in a % enable column, then you would use 0.5. For 100%, 1. For 0%, 0.

Replace the values in your nested IF statement and then you should be able to have your column set to %.

Hope this helps, but if you have any problems/questions then just ask! 🙂

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.