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

...I does not equal "Not Reviewed". =COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport")*('Pivot Table'!I:I<>"Not Reviewed") I should get back 5 "Reviewed" but my formula is returning 6 "Reviewed", the same total as number of "Refusals"...

...by using the following formula: =COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport")*('Pivot Table'!I:I<>"Not Reviewed") Results are: Refusal - 48 Reviewed - 48 The number of “Refusals” are correct , but the number of...

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