How do you formulate an IF function where if the value of Field "C" is less than 70,000, then the value of Field "Tier 2" is not formulated?
Right now, this is what I have:
event.value = (70000-this.getField("C").value)*0.2;
Almost... Try this:
var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;
Even though the value "Not Commissionable" didn't populate (not your fault as I was just testing the software), thank you for your response! Your formula worked for what we needed it for!
Make sure you set the field's Format to None for it to work.
I changed "Not Commissionable" to "0" and it's formulating exactly how I need it to.
Thank you again for your help!