Simplified Field Notation (Subtraction) and setting a range

[first.officer]

Hi all,

Have a problem - have a field (C) that calculates the simplified field notation (A-B). This all works fine, but what I need to do is allow the calculation to do what it does, but one it reaches a certain value (3500.0), the subsequent figures in excess of this figure should not populate the (C) field, and it should remain fixed at 3500.0. If the calculation (A-B) then drops below this 3500.0 threshold, the calculation should resume in calculating the (A-B) in the normal way....possible with script??

Thanks

[Nesa Nurani · Accepted solution]

See if this works for you, put it in "C" field as "Custom Calculation Script":

var a = this.getField("A").value;
var b = this.getField("B").value;
var c = a-b;
if(c >= 3500.0){
event.value = 3500.0;}
else event.value = c;

[first.officer]

Nesa, thats genius! many thanks for that, works beautifully!!!