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

Getting Previous Term from Current Academic Term

Started by sm15, 07 Aug 2013 10:46:21 PM

Previous topic - Next topic

sm15

 ???Hi,

I am new to working ti Cognos report studio and am working with student data where I need to get the Previous Academic Term for a student and have the current Academic Term in a REPORT.

Sample data set:

Academic Term     Academic Term Desc   Enrolled Indicator   Student Status   
201041              Fall 2010                     Y                             Active   
201111              Spring 2011                     Y                            Active   
201121              Summer I 2011             N                             Active   
201141              Fall 2011                     Y                             Active   
201211              Spring 2012                     Y                             Active   
201221              Summer I 2012             N                             Active   
201241              Fall 2012                     Y                             Active   
201311              Spring 2013                     Y                             Active   
201321              Summer I 2013             Y                             Active   
201331              Summer II 2013             Y                             Active   
201341              Fall 2013                     Y                             Active   Current Term
201401              Spring 2014                     N                             Active   

I have all the columns as data items in a Query. How do I get the PREVIOUS TERM a student is Enrolled for (eg If Current Term is 201341, the previous enrolled term will be 201331)?

Thanks for all the help.

Saurabh