Search results for query: *

Thank you for your help!

Formula: {Hours 1} - {Hours 2} = 28 hours I want it to return the total, but maximize at 24 How do I write the formula for this?

Good morning - I finally got to try the formula and it does work great. How can I find out what the 3rd fastest truck?

I have not tried it - I am having problems with connection to my database. Hopefully I can tomorrow. Question - what if I want to know the 3rd fastest?

Hi Pete - I am trying to get the 2nd fastest truck. I think what you described would give me the 1st truck. Thanks - Lynn

My data consist of records with Incident Numbers. Within these incident records are several trucks with a response time attached to each truck: Incident Number - 160039 Truck - E34 ____ Response - 2.85 Truck - E35 ____ Response - 2.83 Truck - T34 ____ Response - 6.30 Truck - A35 ____...

I want to start the first page of my report at page number 5 and the following pages to increase by one. How do I do this? Thanks for your help.

Yes - I do. I meant to type 1.5 - but thanks!

Great! That worked. Thanks for your help.

I have two fields: {Coverage.TOTALHOURS} which displays as "1.00" {Coverage.TOTALMINUTES} which displays as "30" - No decimal point Formula is: {Coverage.TOTALHOURS} + {Coverage.TOTALMINUTES} Because the {Coverage.TOTALMINUTES} does not have a decimal point, it returns "31.00" - I need it...

No I do not have null values.

That worked! Thanks so much!

I have a text field that I converted to a number. I am not able to get a sum of the new number field. The I have tried the following formulas. Formula Name: NumPerson1 Formula: ToNumber({IncdApps.NUMBEROFPEOPLE}) I place this formula in the report and the field shows up as a number. I insert...

It Works! Thanks for all your help!!

Wow - that is great. Thanks!!

Yes they do have headings. I seem to run into trouble when I have multiple criteria, e.g. "No Treatment,No Transport" , "Treatment,No Transport", as in the one I am trying to fix. The formula you sent me works but there is not multiple criteria in it. I do have this formula for another column...

Based on the sample database below using the formula: =COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport") I get 6 "Refusals" returned, which is correct. I tried using the following formula to get a count of "Refusals" that have been...

In Column F, I am getting a total of "Refusals" based on the following formula: Column F – Number of Refusals =COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport") Column I - List different types of Review Status, such as "Complete", "In...

I can not thank you enough. This works perfectly with the pivot table!! Again - thanks for your time and expertise.

Sorry for the delay in responding - I have been in marathon meetings! A big thank you to both of you! I appreciate how much time you are spending to help me. Thanks for sending me the test files. I think the pivot table is the way to go. I'm going to test it out on my database. I'm not that...