community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #183: Roman Numeral Math

Alteryx Certified Partner

Problema solverant:

 

Spoiler
Screenshot 2019-10-07 at 12.29.33.pngScreenshot 2019-10-07 at 12.29.41.png
Nebula

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 

 

 

It technically works.

Meteoroid

PFA my solution

Alteryx
Alteryx
Spoiler
Capture.PNG

Bolide

Bit convoluted in the middle but got there eventually.

Alteryx
Alteryx
Spoiler
Challenge183.PNG
Alteryx Certified Partner

My solution

 

Spoiler
challenge_183.PNG
Alteryx Partner

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
Alteryx Certified Partner
Spoiler
Capture.PNG