Formula for balance a stack rank % attainment

[casdaq]

Hello - I am doing a stack rank - including several various types of metrics results. The stack rank is using % attainment - actuals vs. goals. The % attainment for each metric is then multiplied by a weighting and summed to get an overall Total % Attainment. We need to balance the stack rank though, and it has been determined that we do some type of formula to say, "if" you do not meet 100% attainment on each metric that you do not obtain any overage that you may receive. Meaning, if metric 1 has 97% and metric 2 has 120% they would not get the addition 20% for metric 2, it would then only weight at maximum 100% for those metrics that have overage. I have attached a sample of what the stack currently looks like and what the goal would look like. I'm wondering if anyone has a good formula to use in order to accomplish this? I also need to make sure though, if all metrics reach 100% that it does take into account the overage - "if" metric 1 has 100% and metric 2 has 120% they get that 120% in full. Hope I am making sense here. Please respond back if you need further information from me.

I very much appreciate any help you can provide