I am trying to create a report which will compare an employee's current pay rate and the last recent pay rate and will show the percent increase. Here is an example,
EMP_NO VALIDFROM VALID TO RATE
0001 02/02/2010 02/02/2011 $10.00
0001 02/03/2011 12/31/9999 $ 12.00
I am trying to report using 0EMPLOYEE, but can not pull two records to compare. If I use key dates, I can only pull one record which do not serve the purpose. I thought of creating a customer exit variable but sure of the modeling.