How to Update Multiple Fields to Divide Two Rows

[dishamishra]

Hi Alteryx Experts! 

Does anyone know how I can divide two rows of data to calculate a metric? I have attached a file where I have a title in the "Line Item" column for "Result," but I want to update all the values below each of the months so that I divide the numerator row by the denominator row. Any ideas would be super helpful and appreciated!

[joshuaburkhow]

Sure there is actually multiple ways to do this. Here are just two quick and dirty methods

[JosephSerpis]

I mocked up a workflow let me know what you think?

[Kenda]

Hello @dishamishra 

@patrick_digan made this awesome tool called the Multi -Row -Field -Column Formula. Basically it acts as a combination of the Multi-Row tool and the Multi-Field tool. It is helpful here because you want to perform the same calculation that uses multiple rows in multiple fields. 

[grazitti_sapna · Accepted solution]

Hi @dishamishra,

Here is my take on your problem. I hope it helps.

 

 

[dishamishra]

Thank you Joseph! The logic for your workflow makes perfect sense to me, but when I get to the "Multi-Row Formula" step, my "Results" column returns null values throughout. I followed the same configurations you used in your mock up. Any reason for why this might happen (nulls)?

[dishamishra]

Thanks for your quick response! I'm trying out some of the other methods listed here too to see which works best!

[dishamishra]

This is very cool - thanks for sharing! I'm fairly new to Alteryx, but are these developed tools usually available for everyone to use? Or are they beta version ?

[Kenda]

@dishamishra It is not part of the Alteryx set of tools, it is just a macro that my colleague created. You can download it here to add it to your tool palette: https://gallery.alteryx.com/#!app/Multi-Row-Multi-Field/5da9d45e0462d7179c6316cf

[dishamishra]

---

@grazitti_sapna wrote:

Hi @dishamishra,

Here is my take on your problem. I hope it helps.

 

 

---

Thank you for your solution! This one worked perfectly. I also added a ROUND function in the row formula, as Joseph suggested above and I got exactly what I wanted. Thank you!!