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

JORGE4900
8 - Asteroid

Following up on @SeanAdams iterative macro solution, here a similar one.

I was impressed by @AdamR_AYX  & @patrick_digan  discussion of using %Question.FieldName% to pass users' field names and values.

However, I could not figure out how to only accept one field from the user but keep iterating more variables--(Factor, Factorial, & Message).

 

Spoiler
2019-07-12_9-49-00.jpg
JORGE4900
8 - Asteroid

Hello @Kenda 

 

This batch macro is an excellent approach using the value for the control parameter to generate the rows. I also noticed that once you run the macro, it converts the defaulf value to text as seen here.

 

Well done; that was a pretty good idea.

 

Spoiler
2019-07-12_14-45-32.jpg
JORGE4900
8 - Asteroid

Hey @Treyson 

 

Pretty good workflow; I was expecting the negative factorials results go positive negative like this: −2! = −2 −2 + 1! = −2 * −1 = 2

 

Check out this reference.

LukeG
Alteryx Alumni (Retired)
Spoiler
Challenge_74_LG.PNG

My Solution. Used generate rows and multi-row formula

CliffordC
Alteryx Alumni (Retired)

Pretty much the same as everyone else.

joemkcarr
8 - Asteroid
 
TonyaS
Alteryx
Alteryx
Spoiler
Macro74.PNG
Tonya Smith
Sr. Technical Product Manager, cloud App Builder
fmeo
8 - Asteroid
Spoiler
74.PNG
bkclaw113
9 - Comet
 
IvyM
7 - Meteor

Very first Macro!