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!

  • Congratulations gkittelson 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: *

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

Part and Inventory Search

Back
Top