Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Help with calculated field with multiple "else if" statements

Community Beginner ,
Jul 10, 2023 Jul 10, 2023

Hi community,

 

I'm trying to write a custom calculation script for a field, based upon the values entered into a second field. I'm getting a syntax error that I can't solve. I am sure that I have some sort of simple error that is causing it to fail. Here is my script:

 

var SS = this.getField("Score - Safety").value;

if ( SS >= 97) event.value="A+";
else if (SS >= 93) && (SS < 97) event.value="A";
else if (SS >= 90) && (SS < 93) event.value="A-";
else if (SS >= 87) && (SS < 90) event.value="B+";
else if (SS >= 83) && (SS < 87) event.value="B";
else if (SS >= 80) && (SS < 83) event.value="B-";
else if (SS >= 77) && (SS < 80) event.value="C+";
else if (SS >= 73) && (SS < 77) event.value="C";
else if (SS >= 70) && (SS < 73) event.value="C-";
else if (SS >= 67) && (SS < 70) event.value="D+";
else if (SS >= 65) && (SS < 67) event.value="D";
else event.value = "FAIL";

TOPICS
JavaScript
213
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
1 ACCEPTED SOLUTION
Community Beginner ,
Jul 10, 2023 Jul 10, 2023
LATEST

Solved by parentheses.

var SS = this.getField("Score - Safety").value;

if ( SS >= 97) event.value="A+";
else if (SS >= 93 && SS < 97) event.value="A";
else if (SS >= 90 && SS < 93) event.value="A-";
else if (SS >= 87 && SS < 90) event.value="B+";
else if (SS >= 83) && SS < 87) event.value="B";
else if (SS >= 80 && SS < 83) event.value="B-";
else if (SS >= 77 && SS < 80) event.value="C+";
else if (SS >= 73 && SS < 77) event.value="C";
else if (SS >= 70 && SS < 73) event.value="C-";
else if (SS >= 67 && SS < 70) event.value="D+";
else if (SS >= 65 && SS < 67) event.value="D";
else event.value = "FAIL";

 

View solution in original post

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 10, 2023 Jul 10, 2023
LATEST

Solved by parentheses.

var SS = this.getField("Score - Safety").value;

if ( SS >= 97) event.value="A+";
else if (SS >= 93 && SS < 97) event.value="A";
else if (SS >= 90 && SS < 93) event.value="A-";
else if (SS >= 87 && SS < 90) event.value="B+";
else if (SS >= 83) && SS < 87) event.value="B";
else if (SS >= 80 && SS < 83) event.value="B-";
else if (SS >= 77 && SS < 80) event.value="C+";
else if (SS >= 73 && SS < 77) event.value="C";
else if (SS >= 70 && SS < 73) event.value="C-";
else if (SS >= 67 && SS < 70) event.value="D+";
else if (SS >= 65 && SS < 67) event.value="D";
else event.value = "FAIL";

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines