Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zidol
  • Content: Threads
  • Order by date
  1. zidol

    Maximizing a total at 24

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

    Display Second Fastest Truck

    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 ____...
  3. zidol

    How to change the start page number in crystal?

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

    Adding a decimal point to a number

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

    Trying to sum a text field that has been converted to a number

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

    "Countif" with a Condition Question

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

    Eliminating Duplicates in Excel

    We are in need of help with an Excel formula. Below are two examples, the first one of the raw data and the second one shows the data how we need it to display after the formulas are applied. Column A – Pt ID (patient id) - This column in the spreadsheet can have multiple rows with the same...

Part and Inventory Search

Back
Top