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 strongm 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. michelin

    Average of Elapsed time

    @Charlyi. never mind. i got it! i used the tree formula trick. thank you very much for your help!
  2. michelin

    Average of Elapsed time

    like I would like to summarize the elapsed time... but i get an error, that this formula can't be summarized.
  3. michelin

    Average of Elapsed time

    I get an error using formula 2 for emin: A number, currenct amount, boolean, date, time, date-time, or string is expected here. Am I doing something wrong? I really really appreciate your answer!
  4. michelin

    Average of Elapsed time

    I don't think i'm following you...calculate minimum of what? maximum of what? would you mind to give me an example using my data? I apologize about any inconvenience.
  5. michelin

    Average of Elapsed time

    I have a difficult time to average "minimum" times: datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident})) I have two incidents: Incident I Unit Time Assigned Time AtScene A 00:05:00 00:06:00 B 00:01:00 00:10:00 Incident II Unit Time Assigned Time...
  6. michelin

    Time Difference Formula

    BettyJ... THANK YOU VERY MUCH!!!!! that worked like a charm :) You made my day!
  7. michelin

    Time Difference Formula

    Thank you Betty, I will try it! Skip, thank you for your response. I really appreciate it! 1.the format is actually date.time, so it contains a date also (i'm just showing times, i'm sorry if it made my example confusing). 2.correct. I have one table. My report is grouped by incident and i'm...
  8. michelin

    Time Difference Formula

    Thank you for your questions! So, I have 2 units that are responding to a call. Unit Time Assigned Time AtScene A 10:25:00 10:30:00 B 10:26:00 10:27:00 I need to know, what is the difference between time first unit assigned and time first unit at scene (I need to know how...
  9. michelin

    Time Difference Formula

    I have following data: Time A Time B 10:25:00 10:30:00 10:26:00 10:27:00 I need to know the time difference between the soonest time from column A and the soonest time from column B (which would be 2 minutes). What formula would you advice to use? I'm...
  10. michelin

    average- time formula

    my highlighted incidents are car incidents (B, D). Incident A is a bike incident. Incident C is blank (doesn't have a type). So I said that if an incident is a car incident then highlight the results. But I don't want this incident to be count in an average. Does this make a sense?
  11. michelin

    average- time formula

    Hi, I need a help to write a formula. I have following data: Incident time difference A 00:02:00 B 00:03:00 C 00:02:00 D 00:06:00 Incidents B and D are highlighter incidents. I need them to stay in my...
  12. michelin

    Sum function

    Hi, this might be very easy but for some reason it doesn't work for me. I have a number fields like 3,2,45,98,107... I need to subtract those numbers (result: 255) but it doesn't work. i tried to use a sum field formula to summarize those number but for some reason it doesn't work. I've got an...
  13. michelin

    Crystal Reports Time formula

    I'm using Crystal Reports v12. I have following data: Unit A Arrived Unit B Arrived Difference 08:29:14 08:29:27 00:00:13 14:11:44 14:11:32 23:59:48 Is there a way how not to get 23:59:48 but of example -00:00:12? Thanks!
  14. michelin

    Navarre report scheduler v5

    I’m currently using report scheduler- Navarre v5. Is there a way how could I schedule a report from SQL view? Thank you! Any advice is appreciated.
  15. michelin

    formula for the data

    I've got it. I add to the header a field from the database {responsedate} and I formated it to see January-2013. :)
  16. michelin

    Crystal Reports and SQL reports scheduler

    Thank you very much! It is really helpfull!
  17. michelin

    formula for the data

    Is there some kind of way (I guess a formula) that I could use in the header to see what data is in report? For example. The date range I'm using in my report is "last full month"- in my case- January 2013. Report is scheduled to be sent out every month on the 1st. The header says data range...
  18. michelin

    Crystal Reports and SQL reports scheduler

    What kind of software would you advice for report scheduling?
  19. michelin

    average time

    I know, I'm sorry. I realized that I post it to wrong category and I didn't know how to delete it.. :(
  20. michelin

    time average

    Thank you lbass, but for second part (@null) it says that a time is requiered here. what i did was that i run total: field to summarize: datediff ("s",{start},{end}) type of summary: average evaluate: I use a formula: {table.incident} like "V*" reset: never. i almost got it right but: one...

Part and Inventory Search

Back
Top