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!!
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.
Thank you, @Luke_C!! I'll try it out!