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 strongm 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: LZido
  • Content: Threads
  • Order by date
  1. LZido

    Converting String to Number Question

    I have a field that is a string {Property.LANDINGZONE}. The formula below is not returning the correct results. I am assuming I need to convert the string into a number, but not sure how to do this. if {Property.LANDINGZONE} in "0" to "7500" then 1 else if {Property.LANDINGZONE} in "7501" to...
  2. LZido

    CANNOT CALCULATE IF AND THEN FORMULA

    I have a formula that scores 3 different criterias: 0 or 1 hydrant (with less than 1000 GPM) = 3 1 at 1000 GPM or over and 1 less than 1000 GPM = 2 1 hydrants at 1000 GPM or over = 1 In my data: {@WaterSupply} is valued at 1293 {@WaterSupply2} is valued at 1435 Formula: if {@WaterSupply} <...
  3. LZido

    Grouping by 24 hour time periods from 8:00:00 - 7:59:59

    I am trying to group data by 24 hour time periods. For instance the first time period is from 1/1/2014 8:00:00 to 1/2/2014 7:59:59, the second 1/2/2014 8:00:00 to 1/3/2014 7:59:59, the third 1/3/2014 8:00:00 to 1/4/2014 7:59:59, etc. I could set up groups by a specified order, but that would...
  4. LZido

    Excel - Look for Duplicates and Put in Order based on another Column

    I need a formula in Column B that will look for duplicate INCIDENTNUMBER from column A and then put them in order based on Response times in Column C. Example: there are three incident numbers "150013" in column A. In column B, I need to see the order based from lowest response time to highest...
  5. LZido

    &quot;A formula cannot refer to itself&quot; - Quandary

    I have a formula that states if {@FLSA D11}is greater than the total of {@OtherOT} then minus {@OT D11} and receiving an error - "A formula cannot refer to itself, either directly or indirectly" Problem Formula FLSA D11 if {@FLSA D12} <= 0 then Sum ({@ODC Hours D11}...
  6. LZido

    Formula Will Not Display in Header

    I have a formula that will not work in the Report Header but will work in Details. I created a formula to add a day to a parameter date {?Start Date}+1. I did this for 7 days. I then wrote a formula to give me the total hours based on type of hours for each day. First formula: This is based on...
  7. LZido

    Need multiple dates with data on one row.

    I am trying to create a report where all the personnel's data (date, type of hours, total hours) are on one row in order to export to excel. The problem is there are multiple dates for one person. Each date has a corresponding type of hour and total hours. My data consist of; Personnel...
  8. LZido

    Sum of Group Totals

    I am trying to get a grand total for all groups. I have groups with totals for items and totals for cost. I multiple the total items by their cost. ITEM (each of these are groups) QNTY (this is a group summary) COST (@TotalCost) Adult Cric Kit...
  9. LZido

    Suppress a record

    I am trying to suppress a text field if the date field is greater than a certain date.

Part and Inventory Search

Back
Top