Help writing custom calculation similar to an IF stmt in excel.

[whitneyr123]

Hi! I need help writing a custom calculation.  Basically, If Box 1>Box 2, then value should be Box 1- Box 2.  Otherwise, box should be blank. How do I do this?

[try67 · Accepted solution]

var v1 = Number(this.getField("Box 1").valueAsString);
var v2 = Number(this.getField("Box 2").valueAsString);
if (v1>v2) event.value = v1-v2;
else event.value = "";