Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #176: Math Class Drill

Highlighted
Fireball

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/https://www.xkcd.com/1856/

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution.

Spoiler
12-08-_2019_17-50-25.png
Highlighted
Alteryx Certified Partner

My solution. Could have pivoted also...

 

Spoiler
Capture.PNG
Highlighted

Fun!

Spoiler
176.png
Highlighted
Magnetar
Magnetar

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.
WeeklyChallenge176.JPG

Cheers!

NJ

Highlighted
Comet
Fun! Solution Attached
Highlighted
Asteroid

Great Challenge!

Spoiler
Solution-Challenge 176.PNG
Highlighted
Asteroid
Spoiler
challenge176_viveknshah.JPG
Castor
Castor

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

 

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

WF.png


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

Highlighted
Magnetar
Magnetar
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.


Capture.PNG