alteryx Community

# 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.

## Challenge #176: Math Class Drill

Alteryx

A solution to last weeks' challenge can be found here

The end of summer is near, and it's nearly time to head back to school! Get your brain back into the swing of things with this math class drill. @KaneG  found this problem in his desk on a piece of paper, and he thought it'd be heaps easier to solve in Alteryx. Is he right?

https://www.xkcd.com/1856/

16 - Nebula

My solution.

Spoiler
16 - Nebula

My solution. Could have pivoted also...

Spoiler
12 - Quasar

Fun!

Spoiler
ACE Emeritus

I love the smell of math in the morning.

Spoiler
My solution - 371! I like that it's only 1 off from one of the other known answers, 370. Gotta love the power of one.

Cheers!

NJ

11 - Bolide
Fun! Solution Attached
8 - Asteroid

Great Challenge!

Spoiler
8 - Asteroid
Spoiler
19 - Altair

And there I was ready to say "001".  Doh!

Spoiler
Like @PhilipMannering and @RolandSchubert, I went for single formula solution

A very repetitive single formula

``````Pow(tonumber(Substring(tostring([RowCount]),0,1)),3) +
Pow(tonumber(Substring(tostring([RowCount]),1,1)),3) +
Pow(tonumber(Substring(tostring([RowCount]),2,1)),3)``````

Dan

16 - Nebula
Spoiler
My first thought was to generate numbers 0-9 then append them a couple times to get my list of possible numbers. This left 0 as a possible first number, but none of these turned out as answers so I left it as is.