need to get an average
Posted on 2013-02-01
I am trying to get the average pay for a group of people, but the way the database is setup everytime someone gets a raise it is a new entry, so someone could have 1 entry or 20. This is screwing up my average because it is taking the average of what they originally got paid through what they are making now and I just need their latest pay rate.
For instance this is what I see
Joe Mc $8
Joe Mc $8.50
Joe Mc $10
John Cour $9
Average = $8.88 where it should be $9.50. Joe should only count the one time.