kdavis6416
Technical User
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!
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!