Crystal 9 Sum on Formula Field Type = Number 2

[fcullari]

I have a crystal report where I needed to calculate the difference between when a help desk call was opened and then when it was responded to. I have been many days working on this, because I had to incorporate the Business Days and Business Hour formula's. Having done all that I have come up with a way to setup a formula that can figure out if the call was within 2 hours no matter what time it was opened. Now I'm having a problem with getting my formula to sum. When I check the field type it is a number, but when I go to the summary drop down list, the field does not show. Does anyone have any suggestions?
Formula Field is @On Time = IF ({@Within Response Time}) = 1 THEN 1,
the other field is @Not On Time = IF ({@Within Response Time}) = 0 THEN 1
and the #Within Response Time = IF {@Business Days} <= 0 and {@Business Hours} < 2.00 THEN 1 ELSE
IF {@Business Days} = 1 AND {@Business Hours} IN -7.00 TO -10.00 THEN 1 ELSE 0

 

[synapsevampire]

Consider a Running Total of type Count with the following in the evaluate->use a formula criteria:

({@Business Days} <= 0 and {@Business Hours} < 2.00)
OR
({@Business Days} = 1 AND {@Business Hours} IN -7.00 TO -10.00)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[fcullari]

Synapsevampire,
The only problem with a running total count is that I need a separate count of the On Time Calls and the Not On Time Calls. How do I sum The Count field which has true and false in it. I already determine what bucket the calls belong in, all I want to do is sum the bucket. How come in version 8.5 I was able to do this, and now I Can't?

 

[kenhamady]

I am pretty sure that you wouldn't have been able to do this in v8.5 either. When you can't sum a formula it is usually because the formula uses a summary operation, a running total or some other 'WhilePrintingRecords' operation. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[fcullari]

Ken,
Thanks, I was using a formula with While Printing records, I was not aware that when using this it would inhibit you from summing formula fields. That was the problem, and has been corrected. I'm fairly new to creating Crystal Reports .