Search results for query: *

Hello, I am using Crystal 11. I'm trying to create a report that will show how many operating rooms are running for a particular hour of the day. I am using the patient's in room time and the patient's out of room time. Using these two fields/times helps me to count the number of CASES for...

[bigsmile]Hi Pete, I've decided to do my calculations manually. this is causing me way too many headaches. Thanks again for all of your help, you've been great......ttyl :o)

Hi Pete, I'm not getting any error message, but I'm getting 0 as the results. This is what I have: In the GF: WhilePrintingRecords; Global NumberVar RT15_16; RT15_16 / ({?End Date} - {?StartDate} + 1) and in the RF WhilePrintingRecords; Global NumberVar T15_16; Global NumberVar RT15_16 :=...

Hi Pete, I tried using the formula but I got an error message saying that a "number is required here" {?StartDate} is highlighted.

Hi Pete, I am determining my date range by using two parameters. StartDate and EndDate.They are set up to not allow for a range.

Thanks for your help Pete. I apologize for the vague examples. Your second description explains what I'm trying to accomplish best. When I used the second formula I got an error message that "this field can not be summarized". At this point I don't know what else to do . You have given me...

Hi Pete, I am still using the code that you gave me in the previous thread. I was running the report for one day, but now I am running the report to get a months worth of data. I do have the report grouped by day.In the running total I have the field to summarize @3-4hour, evaluate on change...

Ok, I'm sorry I'm doing such a crappy job of explaining this. I've been tasked to get the average number of rooms running per hour for each day. I am running the report for three months. If a case was running in a particular hour a 1 populates, if not it's a 0. There could be a total of 68...

Hi Pete! The RT is set to average, but it is returning 1. This is the same report that you helped me with in thread767-1715296. It is doing an average counting all of the detail lines instead of only those that have a one value. For instance: it is (1+0+1+1+0)/5 I want it to be (1+0+1+1+0)/3

Hello When doing a running average or just average it there a way to exclude 0's that are in details.. I have a report that I am summing the number of rooms that are running. For every hour it either counts it as a 1 if there was a case for that hour or a 0 if there was not. At the group...

Hi Pete, The formulas work perfectly!!! Thank you so much for ALL of your help. :o) Val

I took off the Summary fields and It works!!!! I have a patient that came in at 21:35 and didn't leave until 01:05. they showed up in all hours preceding and after 12 midnight! Thanks Pete!!!! Will you show me how to use variables to total.........

Hi Pete, Thank YOU!! The formula saved without any errors being found. However, when the report runs I get a message saying that " A summary has been specified on a non-recurring field." This is what I have: WhilePrintingRecords; Local NumberVar IT := {v_CRA_20_Billing.time_pacu_start}...

Hi Pete, Thanks for responding. I will continue to try different things until I hear back from you. Thanks Val

Hello, First I'd like to take this opportunity to say thank you for providing me with an excellent solution to my report to capture recovery room times. I have written 24 formulas for each hour that the patient can be n the recovery room. I am having an issue with the formula for 12 midnight...

It works! Thanks so much for all of your time and effort to help me with this. Now I just have to make 24 formulas!!! Thanks Pete.

Yes, it is a number not text.

Is there anyother way for me to get the results that I need?

I'm sorry Pete, I have limited access to the system. I am not able to provide the way the field is structured in the database. I can only tell you that the ({v_CRA_20_Billing.time_pacu_start}) field in crystal says that it is a number. Thank you for all of your replys. Val

Yes Pete, that is the exact formula that I am using. and that is the formula that you posted for me to use. it is returning zero. I tried to replace your formula with the formula below, but the "a date-time field is required" message appeared. @0RStarttime is a time field. If Not (...