Hi,
How do I calculate a % for the Group Totals ?
%age = ((CurrentYear - PreviousYear) / PreviousYear)
Thankstry sum( ((CurrentYear - PreviousYear) / PreviousYear) )|||If you want the percentage for the entire group, I'd do it as %age =(sum(current year) -sum(previous year))/sum(previous year).
if you do %age = sum((current - previous)/previous) you'll get the sum
of all the individual percentages|||If you want the percentage for the entire group, I'd do it as %age =(sum(current year) -sum(previous year))/sum(previous year).
if you do %age = sum((current - previous)/previous) you'll get the sum
of all the individual percentages|||If you want the percentage for the entire group, I'd do it as %age =(sum(current year) -sum(previous year))/sum(previous year).
if you do %age = sum((current - previous)/previous) you'll get the sum
of all the individual percentages
Showing posts with label previousyear. Show all posts
Showing posts with label previousyear. Show all posts
Monday, February 20, 2012
Percentage Expression
Labels:
age,
calculate,
currentyear,
database,
expression,
group,
microsoft,
mysql,
oracle,
percentage,
previousyear,
server,
sql,
totals
Subscribe to:
Posts (Atom)