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...
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.
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"
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
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}...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.