Dividing Columns by another column

[dkapadia]

Hi All,

Hopefully this makes sense, but I have a workflow that has a bunch of columns that I want to create allocation keys for. I have a set of columns that are broken out by account and another set of columns that have the total for that account. Example below:

Product	Account X	Account Y	Account Z	Allocation for Account X	Allocation for Account Y	Allocation for Account Z
Product 1	10	25	35	30	60	65
Product 2	15	5	10	30	60	65
Product 3	5	30	20	30	60	65

What I want to get to is the below in bold. Doesn't have to be overwriting the columns, happy for it to be new columns if that is easier. 

Product	Account X	Account Y	Account Z	Allocation for Account X	Allocation for Account Y	Allocation for Account Z
Product 1	10	25	35	33%	42%	54%
Product 2	15	5	10	50%	8%	15%
Product 3	5	30	20	17%	50%	31%

Here is the thing though, there might not always be the same number of columns every time I run it. I have a workflow that takes all existing accounts and sums them up and creates new columns. So there will always be a "Account [letter]" column and an "Allocation for Account [letter]" column. I know I can easily do a formula that just divides 1 by the other, but if for some reason there is a new account or an account that is removed, would like the workflow to keep working.

Again, hopefully that makes sense! Thank you so much in advance!

[DavidSkaife · Accepted solution]

Hi @dkapadia 

Here is my take on it, i've ran on the assumption that the Allocation for each account will always be the total for that account:

[dkapadia]

Thank you for the quick reply! That worked perfectly!