Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThanks ChristineB! that was deceptively hard! Originally I tried to use an iterative macro with factorials, but quickly run into field size, and big number challenges that Alteryx has.
Then had to think of another way to skin the cat, that was not brute force 🙂
Solution attached using an iterative macro. The number 1 is included in the result for good measure.
Gave this one a good think ahead of attempting it, went down a few blind alleys and ended up with a simple solution. Want to iterate to solve where 50 can be replaced by 'x' though.