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...
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!
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.