If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Future rates of improvement report.

Started by tschuman13, 04 Aug 2008 03:11:43 PM

Previous topic - Next topic

tschuman13

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!