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.