Decimals appearing in Parent Rows for "% Complete" instead of a % value
Hello!
I've included the screen shot below. The parent rows at the top are rolling up to a % value, but as you can see, the other parent rows below are displaying as a decimal. The child rows under the parent are displaying % complete correctly. I cannot modify the roll-up values. Any idea why this is happening?
Thanks so much for your time and help!
Julie
Best Answer
-
Hello MCorbin,
Thank you so much for your quick response. You were right, I needed to deselect, then select % formatting and they all returned to %. I really appreciate you, have a lovely weekend!
Julie
Answers
-
Most likely, when you formatted those fields, you selected just the cells and formatted them as a %.
Try clicking on the Column Header (which will select the entire column), and then click on the % Formatting option in the menu bar. This may change everything to decimals. Click it a second time, and it will change them to %.
Once done at the column header level, new rows should be formatted correctly.
-
Hello MCorbin,
Thank you so much for your quick response. You were right, I needed to deselect, then select % formatting and they all returned to %. I really appreciate you, have a lovely weekend!
Julie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!