Search results for query: *

That is exactly what I am trying to do .. it works fine in my v8.5 but not in v9. If I change the name of a formula field it does not reflect the name change in the report layout itself but does recognise any difference made in the actual formula itself. Any ideas?

Guys Using V9 and SQL. This is probably a stupid question but ... why is it that when I rename the fields in field explorer that it is not updating the field names in the report? What have I done that I should not have? Thanks!

Hi Guys Using V9 and SQL. I could do with some help on this one ... I need to calculate the time in "days/hours/minutes" left between the current date and time (when the report is run) and the set "must fix by" date and time taking into account business hours and holidays...

Hi Everyone I am being asked to provide a report that gives the average number of calls dealt with per day during a month. The report needs to run for the year from July 2002 to end August 2003. I have used datediff but this is giving me the number of days including weekends but this...

Hi ya Thank you ... it works a treat!!

Hi Everyone I need to create a formula that will add on 4 hours to the time that a call was logged to enable me to work out the percentage of calls completed within 4 hours regardless of SLA. The problem is that if the call is logged at say 5:00 on the 1st then it needs to calculate that 4...

Reebo and Naith Thanks for your help guys! All the suggestions worked a treat (after I had corrected my spreadsheet - doh!). You rock!!

Thanks Naith ... it works like magic if I type in a string but I need it to do this line by line in a 10000+ row spreadsheet that may have 250+ different account names in it .. that change all the time!

Hi Guys I need a way of stripping out unwanted information contained within a string of data. The data looks similar to this .. 0000000888 Fred Bloggs and Son Limited 100000.00 30 00353 99999999 and all I want to use within that is "Fred Bloggs and Son Limited" What formula could...

Hi Everyone I need some help with this one if possible. I have an SLA contract that I have to report on which allows for a next day 17:00 fix. The contract runs from 08:00 to 17:00 Monday to Friday. So, an example, if a call is logged at 08:00 on Monday then it does not miss the SLA until...

I am searching for any mention of a fieldname in a list of helpdesk calls. What do I use to find all instances but limit the output to the unique call number. For instance in call number 50666 there may be three references to the fieldname but I only want the report to give me the call number...