Skip to main content
first.officer
first.officer
Inspiring
November 13, 2020
Answered

Simplified Field Notation (Subtraction) and setting a range

  • November 13, 2020
  • 1 reply
  • 1395 views

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

This topic has been closed for replies.
Correct answer Nesa Nurani

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;

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
November 13, 2020

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
    first.officerAuthor
    Inspiring
    November 13, 2020

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices