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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by omcompany

  1. omcompany

    Help Determining Minimum and Maximum Values…With Exceptions

    Ian, Here is the formula for @min that worked for me, whileprintingrecords; global numbervar min; If {ShotDeckInventory.DeckOrder} <> maximum({ShotDeckInventory.DeckOrder}, {ShotDeckInventory.HoleID}) then min:= minimum({ShotDeckInventory.Quantity}); I am still testing and I am sure this is...
  2. omcompany

    Help Determining Minimum and Maximum Values…With Exceptions

    If I make changes to the following formulas I get correct results for the @max formula. @reset whileprintingrecords; global numbervar min:= 0; global numbervar max:= 0; @max whileprintingrecords; global numbervar max; If {ShotDeckInventory.DeckOrder} <>...
  3. omcompany

    Help Determining Minimum and Maximum Values…With Exceptions

    Ian, The formulas now are correct in that there are no errors. Thank you. However I am not getting the correct results. The end results as well as looking at the data in the details section are all zeros(0). The only exception is that in the details I am seeing the quantity of 2 for Hole 1...
  4. omcompany

    Help Determining Minimum and Maximum Values…With Exceptions

    Ian, I understand and thank you for your quick responses. Once I change min to minimum the error, as expected moves to the next min. I update that min to minimum and so on. Once all min are updated to minimum I get an error saying that, 'The remaining text does not appear to be part of the...
  5. omcompany

    Help Determining Minimum and Maximum Values…With Exceptions

    Ian, Thank you very much for your help. I am getting an error in the min and max formulas. The error comes at the first min (or max) and the error is 'A number, currency...is expected here'. I have it grouped by hole. The exact formula is below. //If section <> min(section, hole) and...
  6. omcompany

    Help Determining Minimum and Maximum Values…With Exceptions

    I have a set of holes and within each hole there are sections. (Picture a cardboard tube divided into sections and each section has a number of units in it.) Each section has a quantity associated with it. I need to determine the minimum and maximum quantity for these sections. The...
  7. omcompany

    Help Determining Fields within a Range and Displaying the Results

    CoSpringGuy No problem on the time, you are doing me the favor and I appreciate it. I am going to be off through the holidays coming and will not get back to the report until December. Any additional assistance is welcomed. Thanks again for your efforts.
  8. omcompany

    Help Determining Fields within a Range and Displaying the Results

    The code above worked with the sample data as well as several other sets. I had to make a very slight change due to my mistake. I stated earlier that the Time Difference criteria was "less than or equal to" but it is only less than. I changed, ({Sheet1_.table#time})) <= {Sheet1_.tabletimediff...
  9. omcompany

    Help Determining Fields within a Range and Displaying the Results

    LB, Thank you for your time. The records are grouped by //@Label({table.X} + ToText({table.Y},0)). Their records are in order of X,Y. For a bit more information/clarification, the record, {table.Time} represents an assigned time (simply a number) not a timestamp. Also, for what it is worth...
  10. omcompany

    Help Determining Fields within a Range and Displaying the Results

    Very nice, thank you. I will be able to take a look on Monday.
  11. omcompany

    Help Determining Fields within a Range and Displaying the Results

    Thank you very much for your time. I will give your suggestion a try.
  12. omcompany

    Help Determining Fields within a Range and Displaying the Results

    Yes. Each record has to be compared to all records to get the difference in time. You would then use that difference result to see if it meets the TimeDiff criteria. There could be hundreds of records with multiple sets of records that meet the TimeDiff criteria. You would then take the maximum...
  13. omcompany

    Help Determining Fields within a Range and Displaying the Results

    The {table.TimeDiff} requirement in the above case is 8 so the Time difference between any of the records that is 8 or less would be considered. The final result would be the records who's sum is the greatest. B1 has a Time of 92 B4 has a Time of 100 Difference of 8 which meets the TimeDiff...
  14. omcompany

    Help Determining Fields within a Range and Displaying the Results

    Thank you for your time. The results from the above data should be; B1, B4 As a side note, A2 and B3 meet the {table.TimeDiff} requirement but the sum of their weight is less than B1, B4.
  15. omcompany

    Help Determining Fields within a Range and Displaying the Results

    My apologies for the title, it was a hard one to summarize. I am using CR 2008. Here is an example of my data and what I am trying to accomplish. ({table.Weight}, {table.Time}, {table.X}, {table.Y}, {table.TimeDiff}) (100, 0 , A , 1 , 8) (100, 25 , A...
See more

Part and Inventory Search

Back
Top