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: *

  1. Sherry B

    Crystal division by zero using if in

    Skip - Yes, I did notice it worked! [bigsmile] Once I confirmed, was hoping you could show me the magic that made it work; sadly, I have no magic in this instance. LOL
  2. Sherry B

    Crystal division by zero using if in

    Skip - Thank you for this. This is exactly how I need to calculate my scores! On my report, I would only show the percentage of Y, I do not need to show the percentage of NA. Thank you!
  3. Sherry B

    Crystal division by zero using if in

    There are over 40 questions in the study. If it won't work, I will just do a score for each employee and then an overall score for all employees. These are report cards so knowing at a glance which questions brought the overall score down would be very helpful. Thank you, Sherry
  4. Sherry B

    Crystal division by zero using if in

    I could not get my example to paste into this section so I'm attaching a file. https://files.engineering.com/getfile.aspx?folder=826d375f-c534-41a3-a1d6-04306929c929&file=example.png
  5. Sherry B

    Crystal division by zero using if in

    Hello – I hope this makes sense as I am new to Crystal. - I need a score for each employee. Formula above works for score by employee. I would never have an NA for both numerator and denominator - I need a score for each question. It is possible to have a NA for both numerator and...
  6. Sherry B

    Crystal division by zero using if in

    Hello - I have a study that has 3 responses, Y, N or NA. I need to divide Y/(Y+N) to create a score. Y=1, N=0 and NA isn't used. I get the error "division by zero" and I'm not sure how to fix it using if in. (If 'Y' in {HFF_HIM_MED_SURGS_Z_VIEW.Z1_Hp_Present_And_Complete_With_All_Elements}...

Part and Inventory Search

Back
Top