Great post! Thanks alot. I have one issue thou. The "Current allocation" percentage Is completely of. It sums up to 700% and should 100% right. What could be wrong?
You are viewing a single comment's thread from:
Great post! Thanks alot. I have one issue thou. The "Current allocation" percentage Is completely of. It sums up to 700% and should 100% right. What could be wrong?
Hmm well that percentage is just a sum and should always add up to 100 as you said. I would ensure the format of collumn F is percentages and then look at the E collumn formula to ensure nothing was accidentally changed. You compare the cell formula to the original sheet in the link above.
If you just cant identify the issue then making a fresh copy never hurts. I do it all the time to troubleshoot :)