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 Rhinorhino 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 Joelcc

  1. Joelcc

    Sum Formula

    TY..Worked Perfectly
  2. Joelcc

    Sum Formula

    Group1:Supervisor Group2:Employee Group1:John Smith SSR? Group2:Larry John 9.38 Mary Sue 7.58 Joe Smith 5.00 The Success Ratio for John Smith the Supervisor for Score of 7 or greater is 66.66%. Two out of the three Employees had => Score...
  3. Joelcc

    Sum Formula

    I'm actually trying to calculate a Success Ratio on the Average Score. So I want to count how many scores are greater than 7 under neath a group and divide it by the total number of scores in that group.
  4. Joelcc

    Sum Formula

    Hello All, I have three formulas: Formula1: Average({Score}, {Group1}) Formula2: IF({@Formual1}>7)Then 1 Else 0 Formula3: Sum({@Formula2}, {Group2}) Formula3 is giving me "The Summary / Running Total field could not be created". When I browse Formula2 Field Type is "Number"
  5. Joelcc

    Date Conversion in 7.0

    Hello, Using Crystal 7, and have a string (20050215) that I'm trying to convert to a Date field 02/15/2005, but have not found a function to do that in 7.0. I appreciate the help
  6. Joelcc

    Field Cannot Be Summarzied

    Hello, I created an If Then Formula where it displays a 1 if a condition is met or 0 if not met. @SSRProdCon= IF(IF{@SignOnDuration} = 0 then 0 Else (Sum ({@AvailableTime}, {VW_CFG_Staff.Staff_Name})+ Sum({@HoldTime}, {VW_CFG_Staff.Staff_Name})+ Sum({@ProdTalkTime}...
See more

Part and Inventory Search

Back
Top