community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Challenge: 5th grade math

Founder
Founder

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?

Alteryx Certified Partner
Alteryx Certified Partner

@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 reboot. Order shall return.
Highlighted

Fun distraction

 

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

 

Spoiler
2017-02-19_22-27-57.jpg

@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

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