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