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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chabotnick

  1. chabotnick

    Writing If-Then using derived fields

    Will do.
  2. chabotnick

    Writing If-Then using derived fields

    I am working from ADP PCPW 4.5 (SQL), using ReportSmith 4.2.
  3. chabotnick

    Writing If-Then using derived fields

    The report runs fine without the deleted derived field. I created a new field and put in only "least(100,800)" I then attempted to run the reports and receive an SQL Execution Error of "Missing FROM clause"
  4. chabotnick

    Writing If-Then using derived fields

    That didn't work either. I used cut and paste to copy your coding exactly and I continue to get the "Missing Right Parentheses" error when I test the derived field. Is there any other information that I could provide that would be helpful?
  5. chabotnick

    Writing If-Then using derived fields

    That still isn't working for me. In the SQL derived field I put the following. least (((REPORTS.V_EXPANSION_FLDS.FIELD22/52)*.667),800) and I receive the message "Missing Right Parentheses"
  6. chabotnick

    Writing If-Then using derived fields

    That, but that didn’t quite work. When I enter it as an SQL derived field, I get the error “Missing Right Parentheses.” If I enter it as a ReportBasic Macro I get numerous errors.
  7. chabotnick

    Writing If-Then using derived fields

    I have a drived field which calculated a dollar amount. I would like to create a field that looks at that field and if the amount is over a set amount (say $800) it returns $800, but if it is less it returns the calculated amount. I've tried using SQL and I'm not really familer with using...
See more

Part and Inventory Search

Back
Top