This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have created a workflow that lists company revenue by state with a total row for each company. I am looking to allocate any positive values across the entire column.
As an example - for Company A in the attached output, I would like to allocate the $9.3M in New York across all states. I tried using the multi-row formula, however, that did not allow me to create a formula that will update rows on condition that the value is positive.
Is there a different tool I can use to accomplish this? Any ideas would be helpful!
Here's a workflow that allocates the positive revenue to the other states.
Start by splitting into positive and other state. Count the number of non-positive records. Use this to determine the amount of revenue to allocate to each state. sum all the totals and the add this to each non-positive state. I wasn't sure how you wanted to allocate the data, so I just used an equal amount to each non-positive one.
Thank you @danilang! This works to allocate the values equally across all the states.
Do you have any suggestions on how to separate the positive and negative values if there are multiple columns? In my sample data, I only presented one company column, but I'm hoping there is a way to apply a filter when there are multiple columns.