Hello,
I calculated the average text box of 3 fields into one text box to get a 1-5 rating. I will need to be able to use the outcome of that text field number to change the text outcome of another text box to reflect the situations below.
0 to 1 = Unacceptable
1.1 to 2 = Below Average
2.1 to 3 = Average
3.1 to 4 = Above Average
4.1 to 5 = Outstanding
Can anyone help me please?
As the custom calculation script of the second field use something like this:
var avg = Number(this.getField("Average").valueAsString);
if (avg>=0 && avg<=1) event.value = "Unacceptable";
else if (avg<=2) event.value = "Below Average";
else if (avg<=3) event.value = "Average";
else if (avg<=4) event.value = "Above Average";
else if (avg<=5) event.value = "Outstanding";
else event.value = "";
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices