I am attempting to build a report where I show the current rate of improvement for a school district. 3 years of data currently exist (2005-2007) and I would like to use the current rate of improvement to predict the rate in 2014 and when the rate will reach 100. Is there a way to do this dynamically? I could accomplish some of this using a list report and creating a calculation for each year to meet the 2014 goal but for schools that don’t reach it by 2014 it needs to adjust dynamically.
Any help or theories on how to accomplish this would be greatly appreciated.
Thanks in advance!