Pass/Fail based on value of another field

[tiam57393835]

I am trying to get the PASS/FAIL field to say Pass if the % Comp is over 95% and Fail if is it less than 95%. Unfortunately, I'm not finding the right combination to get it to work when I change the value. The % Comp is a value that is calculated from other cells as well, I'm not sure if that is the problem or now.

[try67]

Is the other field defined as a Percentage field (under Format)? What is the name of this field?

Should the threshold value be hard-coded as 95%, or is is the value of the "REQUIRED" field? If the latter, what is the name of that field, as well?

[tiam57393835]

Yes they are both formated at percentage.

Right now % Comp is labeled at "Comp", Required = "Required", and Pass/Fail = "Field 1"

[try67 · Accepted solution]

OK, and I'm assuming the value of "Required" is the threshold, not a fixed value. In that case, use this code as the custom calculation script of "Field 1":

var v1 = Number(this.getField("Comp").valueAsString);

var v2 = Number(this.getField("Required").valueAsString);

event.value = (v1>v2) ? "PASS" : "FAIL";

[tiam57393835]

Thank you so much, that worked!!!!!!

[paul.schmeisl@sme-usa.com]

Thanks for this.  I'm performing a very similar calculation.  The above script produces a "Pass" result when the calculated fields are blank.  How can that be changed to remain blank or display "--" until data is input into the calcuated fields?

[Thom Parker]

Replace "FAIL" with "" or "--"

[paul.schmeisl@sme-usa.com]

Thanks.  So to clarify, there are three conditions here that I'd like the pass/fail field to display

1.)  "--" when the %Comp field is blank,

2.) "Fail" when the %Comp field is less than the Req'd field, and

3.) "Pass" when the %Comp field is greater than or equal to the Req'd field.

how do i modify the script to achieve this?

Thanks so much for the help!  

[Thom Parker]

var cV1 = this.getField("Comp").valueAsString;

if((cV1 = "") || isNaN(cV1))

    event.value  = "--";

else

{

  var v1 = Number(cV1);

   var v2 = Number(this.getField("Required").valueAsString);

   event.value = (v1>v2) ? "PASS" : "FAIL";

}