I need help with some calculations that don’t seem to add up properly when dividing a negative percent actual into a positive percent target. Unfortunately for this component, results and targets are percentages, not whole numbers. “Normal math” and “negative target formulas” don’t work for this scenario.
I’ve Google’d, Bing’d, enlisted others and we just cannot seem to figure it out.
Here’s the issue:
Scenario 1:
-15.12% attainment
14.49% target
Scenario 2 - Target Lowered from 14.49% to 2.13%:
-15.12% attainment
2.13% target
Scenario 1 although the target is further away from zero, “normal math” (-15.12%/14.49%) provides a smaller negative result of -104.35%.
Scenario 2 although the target is closer to zero, “normal math” (-15.12%/2.13%) provides a large negative result of -709.86%.
It doesn’t make sense to me that we are lowering the target from 14.49% to 2.13% but the % attainment gets worse…
I feel like I need a formula adjustment but I cannot find one on Google or Bing anywhere and my normal Excel contacts struggle with this one as well.
If you can help - please let me know
Bookmarks