This content has been marked as final. Show 2 replies
// Get the field values, as numbers
var v1 = +getField("box1").value;
var v2 = +getField("box2").value;
var v3 = +getField("box3").value;
// Perform the calculation
var result = 0.9 * (v1 * 32.9 + v2 * 67 + v3 * 75.8);
// Set the value of this field to the result
event.value = result;
You would replace "box1", "box2", and "box3" above with the actual names of the fields you're using. The code could be simplified a bit, but this should get you started. Also, make the calculated field read-only.
thanks alot for this, helped me alot! George you are a Legend!