Multiply or Divide one column by the next one

Question

Greeting!

I'd like to know if there's a way, maybe using Multi-Field Formula Tool, to divide one specific column to the next(or previous) one, here is an example:

I want to create a new column for each month, with the ratio Tax/Value, so it would look like this:

I know I can do it using Formula tool, but the only way I know how to do it is by creating 1 formula for each month, so if I get extended periods, years, I'd need to do numerous formulas. Is there a faster way of doing that?

Thanks in advance!!

vrebelo · Answer

Thank you, @Luke_C!! I'll try it out!

Luke_C · Answer

Hi @vrebelo

Might have overengineered this, but in order to avoid repeating formulas I prefer to transpose the data into fewer columns. The first portion of the attached transposes the data into 3 main columns: Month, Tax, and Value. Then we calculate the ratio just once based on the columns and get it back into your desired format.

New Workflow12.yxmd