Search results for query: *

Okay... I created a s Sub-Report that gives me the data I want to populate in the Pre-Merit field. The reports are not linked. I Just want to display the results from the formula in the Group Footer from the Sub-Report. The date range in the Main is {PRRATEHIST.BEG_DATE} in DateTime (2008, 01...

I am running a salary report, and I'm trying to get the most recent date prior to 2/27/2012. Here is my record Selection {PRRATEHIST.BEG_DATE} in DateTime (2008, 01, 01, 00, 00, 00) to DateTime (2012, 02, 27, 00, 00, 00) and {EMPLOYEE.EMP_STATUS} in ["C", "FR", "PR", "SI", "SU"] and not...

I created these formulas to pull the data.... Main Pre-Merit... Shared Numbervar MyPreMerit; MyPreMerit; SUB Pre-Merit... Shared Numbervar MyPreMerit; if date({PRRATEHIST.DATE_STAMP}) < #2/27/2012# then if ({PRRATEHIST.SALARY_CLASS}="H") then...

I hope this helps. EMPL BEG_DAT Annual PAY_RATE SUB Pre-Merit SUB Post-Merit XYZ 02/17/08 42,905.66 22.00 42,905.66 46,884.24 XYZ 02/15/09 44,192.85 22.66 44,192.85 46,884.24 XYZ 02/13/11 45,518.66 23.34 45,518.66 46,884.24 XYZ 02/27/12 46,884.24 24.04 0.00 0.00...

Sorry, I may have misunderstood. I did a data dump of the table with a select date range of 1/1/2008 - 2/27/21 I used 5 employees. All data was in the details, not sorting done. The results came back with the data I required. No salaries with a date higher then 2/27/2012.

In laswon there is a salary history table. In there is where the dates and salary increases are located. I check in there to see if the records a pulling up correctly.

Why is this not working? if {Salary History.BEG_DATE} = #2/27/2012# then if{Salary History.SALARY_CLASS}="Hourly" then{Salary History.PAY_RATE}*{Salary History.ANNUAL_HOURS} else{Salary History.PAY_RATE} else if {Salary History.BEG_DATE} < #2/27/2012# then if{Salary...

Here goes... Emp ID BEG_DAT PAY_RATE XYZ 03/24/08 50,000.00 XYZ 03/24/08 50,000.00 XYZ 03/24/08 50,000.00 XYZ 03/24/08 50,000.00 XYZ 02/15/09 52,400.00 XYZ 02/15/09 52,400.00 XYZ 02/15/09 52,400.00 XYZ 02/15/09 52,400.00 XYZ 02/13/11 53,400.00 XYZ 02/13/11 53,400.00 XYZ 02/13/11 53,400.00 XYZ...

Ibass... Thanks, but it didn't work. There are some employees that have salary changes on the same day. there is one case where someone received a salary increase and a few hours later was changed to hourly. In that case the salary is the maximum (50,000), but the hourly (25.64) is the...

Nope, not working. The maximum works for the 2/27/2012 date, but in < 2/27/2012 I get the maximum. So, if someone gets 2 merit increases in 1 day (rare, but happens) I get the greater of the 2. I have an employee that went from salary to hourly (salary was an error), it should be giving me...

Yes. I think I may have worked it out by using the "maximum" summary, and changeing if {Salary History.BEG_DATE} < #2/27/2012# to if {Salary History.BEG_DATE} <= #2/27/2012# in order to capture those who did not get a merit increase.

Afer a refresh I get the correct salary for if {Salary History.BEG_DATE} = #2/27/2012# then if{Salary History.SALARY_CLASS}="Hourly" then{Salary History.PAY_RATE}*{Salary History.ANNUAL_HOURS} else{Salary History.PAY_RATE} but I get 0.00 for the other formula if {Salary History.BEG_DATE} <...

Sorry about that... Both formulas give me the salary that is listed on 2/27/2012

I am running a report that pulls from a history table. I have 2 fields... 1- salary on 2/27/2012 (date of merit increase) if {Salary History.BEG_DATE} = #2/27/2012# then if{Salary History.SALARY_CLASS}="Hourly" then{Salary History.PAY_RATE}*{Salary History.ANNUAL_HOURS} else{Salary...

Thank you...I see my error.

Here is the formula I was trying to run... if {data.DESCRIPTION} = ("Regular", "Bereavement", "Paid Bank", "Jury Duty", "Military - Hours", "Temp Disability/Sick", "Temp Dis-State tax exempt", "Temp Dis - Hours", "Temp Dis-State taxable", "FMLA- FLA", "Military Wages to offset reg", "Bank -...