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!
Solved! Go to 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:
Thank you for the quick reply! That worked perfectly!
I tried using the same formula but still throwing error.
I tried using same formula but still getting error . Pls advise
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
so you mean to say data type should be double? If yes, i tried by selecting double but still same error