how to state result of current yr/last yr % increase/decrease
 

When prior year volume = 0, and this year volume = 10, what is correct way to
state percentage increase/decrease?
--
Jane P

Percent change is:

100 (x-y)/y

So, that's x-y/y*100

Percent total is:

100 (x/y)

So, that's x/y*100

HTH

I might be doing something wrong, but that formula doesn't seem to be
working.

this yr = 10
last yr = 0
increase = 10
% of increase over last year = WHAT? (how is WHAT stated as a %? 100% or is
100% only valid if last year had a value other than zero?
--
Jane P


"DNA" wrote:

Percent change is:

100 (x-y)/y

So, that's x-y/y*100

Percent total is:

100 (x/y)

So, that's x/y*100

HTH

Lets think this thru, the zero might be getting you. This is how to calc
percent increase.

Let's say an automobile you wanted to buy was $20,000, but now you see it
has increased to $25,000, what is the percent increase.

First find absolute increase:

25000-20000=5000

The percentage increase is the relative change:

5000/20000=.25

Hope this helps at least the thought process.