Field Calculation Javascript

[bgb6]

Hi, 

I am in need of assistance writing a custom calculation script for a field.

My form includes two fields that include a low and a high value, and another field that has a total value. I need a script to show me the variance if the total value falls outside of the low or high. If the total value falls within the range, it should just say $0.00

Example: Range is $2,000.00 to $5,000.00 and the Total is $5,500.00. I need it to return $500.00. 

Can anyone help me with this?

Thank you in advance!

[Thom Parker · Accepted solution]

See this article:

https://www.acrobatusers.com/tutorials/conditional-execution/

YOu'll need somehting like this in the calculation field for the variance 

var total = this.getField("Total").value

if(total < 2000)

     event.value = 2000 - total;

else if (total > 5000)

    event.value = total - 5000;

[bgb6]

Hi Thom,

Thank you for getting back to me so quickly.

The problem that I have is the Low and High ranges (the 2000 and 5000) are form fields themselves and will vary based on the users entry.

Is the concept similar?

[Thom Parker]

Yes it is, the limit values are acquired and used in exactly the same way as the total

[bgb6]

It worked!!! Thank you so much!