Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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