Forum Discussion
Help with a formula to redistribute percentage change between other values
So I did what I think you want but noticed a problem and propose a variation.
So first off you will have issues manually changing the value and having a formula changing the existing values due to circular references and overwriting formulas so 1st suggestion is to define the original as the 'Default' values. Then have a column for the 'Requested' values and then the output. See the below image (and attached file):
So in this case I requested the Alu cans to be 5% so the 3.46% was equally reduced across all the other items but items that were 0% went to -0.2%. So then I did the change proportionatly so MRF glass at 35.4% changed by -1.24% but HDPE coloured at 0.84% changed by only 0.03%.
Hope that helps
So I did what I think you want but noticed a problem and propose a variation.
So first off you will have issues manually changing the value and having a formula changing the existing values due to circular references and overwriting formulas so 1st suggestion is to define the original as the 'Default' values. Then have a column for the 'Requested' values and then the output. See the below image (and attached file):
So in this case I requested the Alu cans to be 5% so the 3.46% was equally reduced across all the other items but items that were 0% went to -0.2%. So then I did the change proportionatly so MRF glass at 35.4% changed by -1.24% but HDPE coloured at 0.84% changed by only 0.03%.
Hope that helps
