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! 

[RakshaKumar]

Hi 
I'm trying to add a formula to divide rate column by tax rate _1. I'm using below formula but alteryx throwing below error can some one suggest 
[RATE] / [Tax Rate_1] 

[davidskaife]

Hi @RakshaKumar 

You don't need the quotes around the /

[RATE]/[Tax_rate_1] is sufficient

[RakshaKumar]

I tried using the same formula but still throwing error.

[RakshaKumar]

I tried using same formula but still getting error . Pls advise 

[davidskaife]

Hi @RakshaKumar 

Assuming both your inputs are numerical you need to ensure the data type of [Tax Rate] field is also numerical. You currently have it set as a string

[RakshaKumar]

so you mean to say data type should be double? If yes, i tried by selecting double but still same error