We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #284: Division with Macros

justindavis
10 - Fireball
Spoiler
challenge_284_solution_jdavis.PNGchallenge_284_solution_jdavis_macro.PNG
DawnDuong
12 - Quasar
12 - Quasar

Thank you for posting this challenge, it is really interesting. 

The most challenging aspect for me, personally, is how to make the solutions as generalised as possible, such as being able to take in unlimited number of digits and design the logic flow so that it can handle generalised the problem of adding numbers of different numbers of order of magnitudes (e.g. how to handle if the remainders when added together exceed the divisor).

I solved it using 3 iterative macros and this seems to work when tested with extra long numbers.