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

Need Help with combining two formulas and getting a specific rating back

Status
Not open for further replies.
kdavis6416

kdavis6416

Technical User
Dec 1, 2011
6
US
I need help. Here is my situation.

if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} >= 66.5 and {@% Coach} <=77.4 then "Needs Improvement"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} > 77.4 and {@% Coach} <98 then "Effective"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} >=98 then "Outstanding"

Where it is looking at @% Coach I also need it to look at @% Yes in the formula.. Any suggestions on who to do this? Adding

if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} and {@% Yes} < 66.5 then "Unsatisfactory" DOES NOT WORK!
 
Sort by date Sort by votes
do you need to see records other than those that contain {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" at all in your report?

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 
Upvote 0 Downvote
//completed updating formulas 8/19/12 kd
//EMAIL Support
if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=77.4 then "Needs Improvement"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 77.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} >82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} >=98 then "Outstanding"

//PAG
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} < 60 then "Unsatisfactory"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} >=98 then "Outstanding"

//National
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >=98 then "Outstanding"


//National Account Admin. Outbound (Amin Support Rep)
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >= 66.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >=98 then "Outstanding"


//SIG
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 68.5 and {@% Correct} <=80.4 then "Needs Improvement"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 68.5 and {@% Correct} <=80.4 then "Needs Improvement"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}>=98 then "Outstanding"

else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 69.5 and {@% Correct} <=84.4 then "Needs Improvement"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 84.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "Support" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "Support" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SI Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"


//CR
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 68.5 and {@% Correct} <80.4 then "Needs Improvement"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 62.5 then "Unsatisfactory"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=62.5 and {@% Correct} <=87.4 then "Needs Improvement"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 87.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=69.5 and {@% Correct} <=84.4 then "Needs Improvement"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 84.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} >= 68.5 and {@% Correct} <80.4 then "Needs Improvement"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} >=98 then "Outstanding"


//Fraud
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "Support" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "Support" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "FP Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"

//CC
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}>= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "Support" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "Support" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CC Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"



//ASG
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct}> 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"


//TSRII
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//CAM
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//PRN
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//SOHO
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "SOHO Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//ISG
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "ISG Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"



//completed updating formulas 8/19/12 kd
//EMAIL Support
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=77.4 then "Needs Improvement"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 77.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} >82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_Email Form" and {Categories.category_caption} = "WRITING SKILLS" and {@% Correct} >=98 then "Outstanding"

//PAG
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} < 60 then "Unsatisfactory"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PAG Form" and {Categories.category_caption} = "SELLING" and {@% Correct} >=98 then "Outstanding"

//National
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >=98 then "Outstanding"


//National Account Admin. Outbound (Amin Support Rep)
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >= 66.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_NA AO Form" and {Categories.category_caption} = "SERVICE" and {@% Correct} >=98 then "Outstanding"


//SIG
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 68.5 and {@% Correct} <=80.4 then "Needs Improvement"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 68.5 and {@% Correct} <=80.4 then "Needs Improvement"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}>=98 then "Outstanding"

else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 69.5 and {@% Correct} <=84.4 then "Needs Improvement"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 84.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "Support" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "Support" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_SI Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"


//CR
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 68.5 and {@% Correct} <80.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 62.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=62.5 and {@% Correct} <=87.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 87.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=69.5 and {@% Correct} <=84.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 84.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} < 68.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} >= 68.5 and {@% Correct} <80.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} > 80.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CR Form" and {Categories.category_caption} = "Resolution" and {@% Correct} >=98 then "Outstanding"


//Fraud
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "Support" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "Support" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_FP Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"

//CC
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}>= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "Support" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "Support" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CC Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"



//ASG
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 71.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 71.5 and {@% Correct} <=83.4 then "Needs Improvement"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct}> 83.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} < 69.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} >= 69.5 and {@% Correct} <=79.4 then "Needs Improvement"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} > 79.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_ASG Form" and {Categories.category_caption} = "Support" and {@% Correct} >=98 then "Outstanding"


//TSRII
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_TSRII's Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//CAM
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_CAM Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//PRN
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct}> 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "COMMUNICATION" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_PRN Form" and {Categories.category_caption} = "TECHNICAL SKILLS" and {@% Correct} >=98 then "Outstanding"

//SOHO
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} < 66.5 then "Unsatisfactory"
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >= 66.5 and {@% Correct} <=82.4 then "Needs Improvement"
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} > 82.4 and {@% Correct} <98 then "Effective"
else if {@Score Plan} = "AM_SOHO Form" and {Categories.category_caption} = "POLICY AND PROCESS KNOWLEDGE" and {@% Correct} >=98 then "Outstanding"

else if {@Score Plan
 
Upvote 0 Downvote
% Coach fornula
{#COACH}/{@Total Scored}*100

% Correct formlula
{#YES}/{@Total Scored}*100
 
Upvote 0 Downvote
WOW! Ok that answers that question! lol

As far as your formula
if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} and {@% Yes} < 66.5 then "Unsatisfactory"
That one isnt wrking because its looking for a Boolean for coach ... you didnt provide a value

WOW! Ok that answers that question! lol

As far as your formula
if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and [highlight #CC0000]{@% Coach} < 66.5[/highlight] and {@% Yes} < 66.5 then "Unsatisfactory"

replace your own values of course .. not sure what the yes formula looks like

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 
Upvote 0 Downvote
lol .. sorry about the cutting and pasting .. I should really review better before I click Submit Post

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
178
doodledump
D
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
107
BradCustom
BradCustom
chish_nc
  • Locked
  • Question
Need help getting oldest anniversary date to show
Replies
3
Views
163
pmax9999
pmax9999
ggies07
  • Locked
  • Question
Adding two formulas
Replies
4
Views
145
dgillz
dgillz
john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
206
john432
john432

Part and Inventory Search

Sponsor

Back
Top