Grady Turner
New Member
I run a dashboard for my company. They want to add a column on this dashboard which shows percentage of the goal missed. I was able to find the percentage when the goal is a standard numeric value. (Goal 80; Achieved 70 = 87.5%)
The issue I am hitting is I have several goals that are percentage based.
One goal being 99.6% and the goal is to achieve higher than the 99.6%. (last week they achieved a 97.6%)
I have another goal that is 1% and the goal is to achieve lower than the 1%.(last week they achieved 1.4%)
How do I find a percentage of goal missed using both scenarios?
The issue I am hitting is I have several goals that are percentage based.
One goal being 99.6% and the goal is to achieve higher than the 99.6%. (last week they achieved a 97.6%)
I have another goal that is 1% and the goal is to achieve lower than the 1%.(last week they achieved 1.4%)
How do I find a percentage of goal missed using both scenarios?