Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Challenge: 5th grade math

Ned
Alteryx Alumni (Retired)

Another real 5th grade math problem that is easy to solve in Alteryx:

 

"Stretch Your Thinking: I am a number less than 3,000. When you divide me by 32, my remainder is 30. When you divide me by 58, my remainder is 44."

 

How many tools can you solve it in?  Can you get the answer without a Filter tool?

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Ned,

 

Spoiler
IIF(Mod([Number], 32) == 30 && Mod([Number],58) ==44,[Number],null())

I solved it in 6 tools and took your no filter challenge for extra credit.

 

Spoiler
Screen Shot 2017-02-19 at 4.12.08 PM.png

Thanks for the distraction!

 

m

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
jdunkerley79
ACE Emeritus
ACE Emeritus

Fun distraction

 

4 tools (no filter, and 1 is a browse)

 

Spoiler
2017-02-19_22-27-57.jpg
patrick_digan
17 - Castor
17 - Castor

@Ned If you just want one number that meets the criteria, it can be done in two tools plus a browse

Spoiler
Untitled.png

It's essentially combining the Mod formula from @MarqueeCrew with the generate rows from @jdunkerley79

Philip
12 - Quasar

I'm impressed with the elegance of the other solutions. Here is how I approached it before looking at other's. Looks really clunky compared to James' idea. Really missed not using the filter to try to get the number out.

 

Spoiler
NumberProblem.png
Labels