How do I stop my report from generating numbers to the 4th decimal?
Jill Cote
✭✭
Hi!
I'm using a report that is averaging project duration by year. The "Average" function in the report creation is adding 5 numbers to the right of the decimal. Can this be changed? I know there's a ROUND function that can be used in the sheet, but not in the report?
Thanks!
Best Answer
-
Is the source data formatted to show decimals?
Answers
-
Is the source data formatted to show decimals?
-
Hi Paul,
The source data was set to not show decimals. We set it to three decimals, saved it, set it back to 0 decimals, and it fixed the problem!!
Thanks Paul! Have a great day!
-
Happy to help. 👍️
-
Thank you
This helped me as well.
Odd glitch but worked!
-
This technique does not work.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives