Formula - Percent Increase or Decrease
I am trying to show percent increase or decrease in the number of students who obtained a GED in Fiscal Year 2009 to the number of students who obtained a GED in Fiscal Year 2010. My formula:[Formula - 1st FY GED] - [Formula - 2nd FY GED]/[Formula - 1st FY GED]*100
I think the formula is right, but my numbers are these: 6-5 = 1, 1/6 = .16, .16*100 = 16.67%
The answer I get is -10,000.00% . I expect a negative number since there was a decrease, but this is just not working. I have spent many hours of trial and research trying to figure it out. Does anyone know how I can get this to work right in a Summary Report?