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!

  • Congratulations Mike Lewis 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. jazcastle

    EV4 Hosted - Crash when saving to Excel, CSV and Dif

    Are you saving to your local hard drive? When I do that (I'm running on Citrix also)it crashes. I have to save as csv or xls to the I: drive, then open an explorer window and copy the file and paste it into my hard drive. VERY annoying, but it seems to be the only way to do it.
  2. jazcastle

    Need Help - Dividing 2 derived fields

    Nevermind! I got it - it was crashing since it was trying to divide zeros for some people, i guess. I nested it in a case statement: CASE WHEN (TO_NUMBER(NVL( (SELECT SUM("PS_AL_CHK_HRS_ERN"."EARNINGS") FROM "PS_AL_CHK_HRS_ERN" WHERE ((("PS_AL_CHK_HRS_ERN"."CHECK_DT" BETWEEN <<BeginDate...
  3. jazcastle

    Need Help - Dividing 2 derived fields

    I am trying to get an average of money paid over a number of checks that had certain earnings codes. So I added the sum of the earnings as one derived field and the the count of the check numbers that meet the critera as the other derived field. They work just fine alone but I want to divide...

Part and Inventory Search

Back
Top