Recent content by michelin

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

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

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!

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.

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

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

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

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

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

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?

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

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

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!

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.

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