Usually calculated as (this year – year ago) / year ago. Should not be used for measures that are already expressed as a %.
Percent Change (% Chg)
Transforming your syndicated data into business insight
Hi,
I have a question.
My current data looks like this:
% Unit sales by promotion % Unit sales by promo YA
64.44 -4
So for calculating the absolute %unit sales by promotion, I have taken 64.44%*Dollar sales for the current year.
But I’m confused for the column %unit sales by promo YA. Is -4 %pt change from the current year or -4%?
Thank you for your assistance.
Warm regards,
Shiva
Two things here:
– For absolute change in unit sales by promotion you want to multiply the 64.44% * Unit sales, not
Dollar sales.
– The change measure for something that is already a % (like % sales promoted) is almost always point change. So in this case, current % units promoted is 64% and that is down -4 points from last year, so last year it was 68%.