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 Chris Miller 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. jveschio

    Rounding

    How do you truncate to a derived 2 digit field?
  2. jveschio

    If, Then derived field "Missing operands?"

    Hi, I am trying to create a if, then function in a derived field. I am using ADP PC Payroll 4.5 and Reportsmith 4.2 SQL database. The field keeps returning "Not enough operands". The field is below: @IF(REPORTS.V_EMPLOYEE.ANNUALSALARY/12>8333,8333,REPORTS.V_EMPLOYEE.ANNUALSALARY/12) What...
  3. jveschio

    Rounding

    I am having a problem rounding from 45,260 to 46,000. IS there a way to do that? To round up to the next thousand?

Part and Inventory Search

Back
Top