Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #74: Build a Factorial Calculator

Lily_Unsworth
8 - Asteroid
 
T_Willins
14 - Magnetar
14 - Magnetar

My macro solution.

Spoiler
Macro 74.GIF

 

 

MichaelStaig
7 - Meteor
Spoiler
challenge_74_photo.JPG
RWvanLeeuwen
11 - Bolide
Spoiler
74.png
joshuaburkhow
ACE Emeritus
ACE Emeritus

Here is one way to do it. I thought of about 3 other ways too!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Greg_Murray
12 - Quasar

Solution attached

dhtay
8 - Asteroid
Spoiler

Challenge74screenshot.PNG

Happy with myself for finding a relatively efficient solution. 😃

(Also my first time exporting a package)

mcultrera
8 - Asteroid

Since factorials are constant, I didn't see the need to generate them on the fly.  Rather I built them in and then joined them to the input.  Built the factorial dataset by using a multi row field:  row-1: cumulative * current row number.  Really no benefit to using a macro for this method, but I did put it in a macro per instructions and for good practice.

 

Cosmin_S
8 - Asteroid

Nice and easy using a standard macro. 

Thank you. 

ascepkova002
8 - Asteroid

My solution below