Average Children and Round Down
Good Day All:
Can someone help me Structure this Formula so when I Calculate the Average for all Children it is Rounded Down?
Existing Formula Yield 0.00%:
=ROUNDDOWN(AVG(CHILDREN()))
Thanks
Best Answer

Ah. Ok. Percentages are actually calculated as decimals (a percentage of 1). So 6% is actually .06 which does round down to zero. You will want to leverage the second portion of the ROUNDDOWN function to include the number of decimal places. Try starting with a 2.
=ROUNDDOWN(AVG(CHILDREN()), 2)
Answers

What should it be? Are you able to provide a screenshot of the source data?

I want it to Round down to 6%

Ah. Ok. Percentages are actually calculated as decimals (a percentage of 1). So 6% is actually .06 which does round down to zero. You will want to leverage the second portion of the ROUNDDOWN function to include the number of decimal places. Try starting with a 2.
=ROUNDDOWN(AVG(CHILDREN()), 2)

Missing the Value 2. That worked , Thanks

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!