Skip to main content
New Participant
July 13, 2017
Answered

Calculated field but if over an amount equals zero

  • July 13, 2017
  • 1 reply
  • 692 views

I am trying to make a form that uses an input field (Estimated Sales Price of Current Residence) to calculate the Guaranteed Homesale Program value, which is Estimated sales price of current residence x  .15. But if the Estimated sales price of Current Residence is more than $750,000, then I want Guaranteed Homesale Program field to equal 0. I tried the following but an getting errors.

var n = this.getField("Estimated Sales Price of Current Residence").value;

if (n < 750000) {event.value = ("Estimated Sales Price of Current Residence * .15");}

else if (n > 750000) {event.value = "0";}

This topic has been closed for replies.
Correct answer Bernd Alheit

Use this:

if (n < 750000) {event.value = n * 0.15;}

else if (n > 750000) {event.value = 0;}

1 reply

Bernd Alheit
Bernd AlheitCorrect answer
Community Expert
July 13, 2017

Use this:

if (n < 750000) {event.value = n * 0.15;}

else if (n > 750000) {event.value = 0;}

New Participant
July 13, 2017

Thank you!!! If I want to limit the return value to $10,000 how would I also include that?

Bernd Alheit
Community Expert
July 13, 2017

if (n <= 750000) {

  n = n * 0.15;

  if (n > 10000) n = 10000;

  event.value = n;

}

else event.value = 0;