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 #183: Roman Numeral Math

jamielaird
14 - Magnetar

Problema solverant:

 

Spoiler
Screenshot 2019-10-07 at 12.29.33.pngScreenshot 2019-10-07 at 12.29.41.png
danilang
19 - Altair
19 - Altair

Here's my PEMDAS compliant, non-macro solution. 

 

Spoiler
w.png
All the heavy lifting is done in the Multi-Row tool, which converts IX to 9 and adds the brackets necessary so the Summarize tool can create a mathematically correct formula to pass to the dynamic replace tool.

 

Dan 

 

 

Brian_Stoffel
8 - Asteroid

It technically works.

Nacho
6 - Meteoroid

PFA my solution

DanielMS
Alteryx
Alteryx
Spoiler
Capture.PNG

DataBlender
11 - Bolide

Bit convoluted in the middle but got there eventually.

JamesHa
Alteryx Alumni (Retired)
Spoiler
Challenge183.PNG
James Dolan-Hall | Principal Technical Account Manager
support@alteryx.com | community.alteryx.com
JoshuaGostick
11 - Bolide

My solution 🙂

 

Spoiler
challenge_183.PNG
nickjastrzebski
8 - Asteroid

This one was good fun, but ended up getting quite involved! I think I ended up over-complicating things at the end with a string-to-formula macro, but it does work!

Spoiler
image.pngimage.png
LordNeilLord
15 - Aurora
Spoiler
Capture.PNG