Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bronnad

    Lawson History Table help

    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...
  2. Bronnad

    Most recent Date in a query

    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...
  3. Bronnad

    Lawson History Table help

    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...
  4. Bronnad

    Lawson History Table help

    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...
  5. Bronnad

    Lawson History Table help

    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.
  6. Bronnad

    Lawson History Table help

    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.
  7. Bronnad

    Lawson History Table help

    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...
  8. Bronnad

    Lawson History Table help

    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...
  9. Bronnad

    Lawson History Table help

    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...
  10. Bronnad

    Lawson History Table help

    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...
  11. Bronnad

    Lawson History Table help

    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.
  12. Bronnad

    Lawson History Table help

    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} <...
  13. Bronnad

    Lawson History Table help

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

    Lawson History Table help

    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...
  15. Bronnad

    Multi if statement in 1 formula

    Thank you...I see my error.
  16. Bronnad

    Multi if statement in 1 formula

    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 -...

Part and Inventory Search

Back
Top