It wouldn't show as an "incorrect percentage" if you had the correct formula. So
the issue is devising the correct formula, where "correct" is your definition of
correct.

So tell us what you want to achieve. Give us examples, the formula you are using
and where it produces incorrect results. It won't take much effort to get the
right formula.

--
Regards,
Fred


"Analyst_John" wrote in message
...
Unfortunately I can't do that though because if they do have positive growth
on a negative goal, it would show as an incorrect percentage

"Fred Smith" wrote:

I would set all the goals as positive numbers.

A goal of -10,000 growth is also a goal of 10,000 decrease.

Once you have all the goals as positive numbers, calculating the % achieved
is
straightforward.

--
Regards,
Fred


"Analyst_John" wrote in message
...
I am working with a data set that I have to calculate the % to goal
achieved.
For this data set though, some of the goals are negaitve growth goals. So
for example, if the goal is -10,000 in growth, meaning they expect the
balance to shrink, if they are actually -10,000 they have achieved 100%.
If
they lose more than that, they start going below 100% and if they don't
shrink that much or actually grow the balance, it would be above 100%
achieved. This get's weird with the percentages because it calculates that
if the goal is -10,000 and they stay even, (0), that it is 10,000%, but the
way I need it to show is that they were at 200% of goal. So being
at -20,000
would be at 0% of goal, and below -20,000 in growth would be a -%. Any
help
you can give would be great.

Thanks.