Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #308: Size it up

benjamin_feuchter
8 - Asteroid

Resulting percentages based on 1839 rows - I don't think dividing by 1850 is the right approach here.

Spoiler
benjamin_feuchter_1-1647443355550.png

 

 

 

MattBenj
9 - Comet

My solution.

Shawn_Maphoto
7 - Meteor

Hi All, here is my solution

Spoiler
weekly challenge_308_SM.PNG
leonhekkert
8 - Asteroid
Spoiler
Challenge_308.png
Diederik_vanderharst
8 - Asteroid

Voila

Spoiler
Schermafbeelding 2022-03-24 om 09.31.43.png

Shifty
12 - Quasar

For the life of me I can't get the same percentages but I can't see where I've gone wrong! 😬

Spoiler
Shifty_0-1648130419655.png

 

tammybrown_tds
8 - Asteroid

@Shifty,

 

I had the same issue.  The solution in the output uses the SmartRound formula (exactly what you have, except the [Count by Size]/[Total Entries] part of the equation is enclosed by the SmartRound function).  if you do that, your percentages will match the solution.

 

I was never able to fully determine what the SmartRound function does, but it's the only way that the results match the output set.

Shifty
12 - Quasar

Thanks, @tammybrown_tds - I'll take a look at that.  My solution was never going to be "SMART". 🤣🤣

Spoiler
HarleyBarnes_Quantium_0-1648444084025.png

 

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution: