Calculating a percantage with multiple variables

**w8itn4you** · 08-02-2013, 11:12 PM

Please see attached. Any help would be very much appreciated. i dont know if this is possible or not.

I have a table in which i want the percentage ( column G) to calculate automatically based upon a few variables.

There are certain facilities that will grown and some that wont. Those that don't grow, i want the percentage in column g to be the same as in column c.

it is easy to figure if there is only one facility with growth, but if there are more than one, how do i figure that out?

In my example, i have Facility A and I with growth. The rest of the facility will have the same percentage. (the total percentage should not exceed 100%).

**etaf** · 08-03-2013, 03:12 AM

In my example, i have Facility A and I with growth. The rest of the facility will have the same percentage. (the total percentage should not exceed 100%).

i do not see how this would work and maintain a total of 100% , as you are using different totals

unless you want to work out the percentage of the growth facilities against the original total volume

so if you increase the trailers by just one , then all the percentages will need to change , as you are using the percentage of the total trailers and now your trailers have just increased

for example
Facility A has 1
Facility B has 1
so your percent of the total will be 50% for both
if facility A increases to 2
Then facility B can no longer remain at 50% of the total , since they only have 1 out of 3 trailers and so now a 33.3%

what exactly are you trying to show in the new percent figures in column G