Challenge #284: Division with Macros

[lwolfie]

Nice Monday Morning Challenge

[Pilsner]

Wow, that took longer than expected. Such a good challenge, here's my solution:

Spoiler

I managed to solve this problem without a macro, but I did have to do some string coding in the multi-row formula (not the ideal use case, but it helped massively, and I'm trying to practice it since I've seen some of CoG's and gawa's solutions to Euleryx). I did still convert it into a macro as well, as the question asked, but it's just a standard macro with the same tools inside, hence no extra screenshot😄

This challenge also prompted me to read @Gaurav_Dhama_'s post on large numbers, which I've been meaning to revisit for a while. (Here's the link: https://community.alteryx.com/t5/Engine-Works/Handling-Unusually-Large-Numbers-in-Alteryx-Designer/b...

I don't know how applicable it is to this challenge, as it mainly deals with summing numbers, but it's well worth a read. I found it very interesting to learn about the formula tools' behaviour in the background and how it treats all numbers as doubles regardless of the workflow metadata. It was also interesting to know that the summarise tool is exempt from the constraints of "double" data types.

[estherb47]

Love a good mathy challenge. Kept this one simple, and treated the macro as if solving long division by hand

Spoiler

[ChristopherAY2603]

Spoiler