Difference Formula & Selection Criteria

[HRISUser]

I am on Crystal XI and I have a table that contains Dates that Team Members got a pay rate increase. Below is sample data:

Employee ID Pay Rate Beg Date Pay Rate
13 01/01/1998 $7.00
13 02/05/2000 $8.25
13 05/17/2006 $12.50
14 01/01/2006 $10.00
15 07/01/2000 $8.00
15 10/10/2001 $9.00

What I would like to see if the difference between the employee's current rate and their last pay increase. So for Employee 13 I want to see $12.50 - $8.25 = $4.25

I would like to select the two last pay increases for each employee when the employee's Pay Rate Beg Date is in a certain month...so show only Employee's who's Last Rate Effective date is between 5/1/2006 and 5/31/2006

I thought that I could do it as a summary field, but in the summary field there isn't an operation for the difference. Honestly, I am stuck. Any help would be greatly appreciated.

Thanks in Advance!

 

[synapsevampire]

No, a difference isn't a summary.

Saying within a certain month doesn't describe how this month is decided on, do you mean a parameter?

And by month do you mean the most recent month, or 3 years ago for that month would be correct as well? State what you mean, it only takes a few more moments to be specific.

If you use a group by the emp id and use a parameter and a record selection formula for the group of:

month(maximum({table.date},{table.id}) = {?MyMOnthParm}

You'll limit the rows to the same month.

Then you can place the fields in the group footer (sort ascending by the date), and use a formula of:

if previous({table.id}) = {table.id} then
previous({table.date})

Then you'll get the previous raise date.

That should give you something to gnaw on, but you need to share specifics.

-k