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!

Search results for query: *

  • Users: seabubble
  • Content: Threads
  • Order by date
  1. seabubble

    Bank Holiday formula in Excel

    Hi All, I have the following formula in a spread sheet. It works out the total SLA hours in the week from start date to end date. =IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14))-TIME(8,0,0),"Unresolved") This works well if the times are weekdays between 8...
  2. seabubble

    week on week chart

    Hi, I need to show a graph which plots a week on week total of records opened. I am reporting from thursday to wednesday. But the end of week is friday. How do i group the records raised by thursday to wednesday? I know how to do the totals and charts. I just can't get my head around how...
  3. seabubble

    SQL select and group by help

    Hi, This is the first time I have used the SQL forum. At the moment my SQL looks like this (select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') ) this gives me a figure of 1034. I...
  4. seabubble

    Grouping with SQL expression field

    Hi all, I have been working on a report that does distinct counts from the database. The sql below works OK and brings me back the distinct count of all assets. I want to group by region "AST_Asset"."Region" but cant get the syntax right. (select distinct count("AST_Asset"."Asset_ID_") from...
  5. seabubble

    Downloaded business date formula not working

    Hi all, I have downloaded this business date and time formula called cr9_business_days_samples.zip from here http://support.businessobjects.com/communityCS/FilesAndUpdates/cr9_business_days_samples.zip.asp I change the date fields to my ones and check the syntax. Its all OK. I then put the...
  6. seabubble

    adding up dates and times

    Hi, Can anyone help ? I have a formula that converts Remedy time to normal time. DateAdd ("s", {HPD_HelpDesk.Create_Time} + 3600, #1/1/1970#) I have two columns Create date time Close Date Time hh:mm 01/10/2004 12:00 01/10/2004 13:20 1:20 01/10/2004 13:00 01/10/2004 14:10...
  7. seabubble

    SQL expression field syntax

    Hi, This is the first time I have used the sql expression field and I am having trouble with the following simple select statement. select sum("AST_Asset"."Asset_ID_") from table "AST_Asset" where AST_Asset."AST_Asset"."Type" = "ROUTER" It keeps saying that there is an incorrect syntax near...
  8. seabubble

    grouping by formula in footer

    Hi, I have a report that shows region, distinct count, a count of records that match a value and a percentage (this is the formula) I have grouped the region first as I want to sort the records. Then I count the number of items at that region. (distinct count) Then I count the problems...

Part and Inventory Search

Back
Top