Start a conversation

Assign a score based on a percentage

In the calculation you can give a 'score' based on the value of a different field. In the template below, the calculation field value will be 1 if variable_x is in between 1% and 19%, 2 if variable_x is in between 20% and 39%, etc:

If variable_x is... The score is...
In between 1% and 19% (incl. 1 and 19) 1
In between 20% and 39%
2
In between 40% and 59%
3
In between 60% and 79%
4
In between 80% and 100%
5


Template:

var score = 0;
if ({variable_x} >= 1 && {variable_x} < 20) { 
score = 1;
} else if ({variable_x} >= 20 && {variable_x} < 40) {
score = 2;
} else if ({variable_x} >= 40 && {variable_x} < 60) {
score = 3;
} else if ({variable_x} >= 60 && {variable_x} < 80) {
score = 4;
} else if ({variable_x} >= 80 && {variable_x} <= 100) {
score = 5;
} 
score;
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Castor Support Team

  2. Posted