I am trying to layout a report that vertically has the names of individuals. Horizontally, it has position, last raise month etc.. It also has the month of the raise and the amount of the raise. 2 Problems. I am working with a one to many relationship. If there are 2 raises during the past year the 2nd salary increase does not show up (I am using a calculated field.. If I had a pay raise in January and April - Only the first increase shows.
If month({XHR_SalaryHist.EffectiveDate}) =
{@11 month}
And year({XHR_SalaryHist.EffectiveDate}) >=(Year(today))-1
then {XHR_SalaryHist.SalaryRate}
Second - is there a way to calculate the difference in pay from the last pay recieved. The pay history file only has the new amount. So I would have to look at the previous date of increase and use a formula to do this.
IP Logged