???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