Comparing Field 'A' value with Field 'B' value...

[first.officer]

Hi,

Am trying to come up with the script to compare the numerical value in Field 'A', and compare it to the numerical value in Field 'B', and if numerical value 'A' is greater than numerical value 'B', add text "NO", and if numerical value 'A' is less than value 'B', add text "YES" (otherwise field is blank). The "YES" or "NO" would be added to a field 'C'.

I'm sure its fairly straightforward, but can't seem to fathom....

[Nesa Nurani · Accepted solution]

Use this code as FieldC "Custom Calculation Script":

var a = this.getField("FieldA").value;
var b = this.getField("FieldB").value;
if(a > b){
event.value = "NO";
}else if(a < b){
event.value = "YES";
}else
event.value = "";

[first.officer]

Thanks Nesa....thats great 😉