Hello,

I am attempting to calculate using three different pick lists and am wondering if there is a better way to do this. The idea is to update a custom field GUDF_LONG3 using the information from GUDF_CHAR41, GUDF_CHAR42 and GUDF_CHAR43 added up together. Each of the pick lists has a value that starts with 0.0, 3.0, 5.0 and 8.0 with one exception being 1.5. These values need to be added together and input into GUDF_LONG3 which I have been able to do, by issues arise if the pick list is changed to a lower or higher value, I am not sure how to get it to recalculate.

1. 
   
2. var brr=$CS.getText("GUDF_CHAR41");
   
3. var tec=$CS.getText("GUDF_CHAR42");
   
4. var cos=$CS.getText("GUDF_CHAR43");
   
5. var risk1=$CS.getValue("GUDF_LONG3");
   
6. var risk2='GUDF_LONG3';
   
7. 
   
8. if (brr.startswith("0.0") ||
   
9.     tec.startswith("0.0") ||
   
10.     cos.startswith("0.0")
    
11. ) {
    
12.  var risk3,risk4,risk5 = "0";
    
13. }
    
14. 
    
15.  else if (cos.startswith("1.5")
    
16. ) {
    
17.  var risk5 = "-1.5";
    
18. }
    
19. 
    
20.  else if (brr.startswith("3.0") ||
    
21.           tec.startswith("3.0") ||
    
22.           cos.startswith("3.0")
    
23. ) {
    
24.  var risk3,risk4,risk5 = "-3";
    
25. }
    
26. 
    
27.  else if (brr.startswith("5.0") ||
    
28.           tec.startswith("5.0") ||
    
29.           cos.startswith("5.0")
    
30. ) {
    
31.  var risk3,risk4,risk5 = "-5";
    
32. }
    
33. 
    
34.  else if (brr.startswith("8.0") ||
    
35.           tec.startswith("8.0") ||
    
36.           cos.startswith("8.0")
    
37. ) {
    
38.  var risk3,risk4,risk5 = "-8";
    
39. }
    
40. 
    
41. var risk6 = parseInt(risk3, 10) + parseInt(risk4, 10) + parseInt(risk5, 10);
    
42. $CS.setValue(risk2,risk6);