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

JerryLouis

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!

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! 🙂