Copy link to clipboard
Copied
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;
if(C<70000)event.value,"Not Commissionable"
I know this isn't correct as I am not a professional with Javascript or Advanced Calculations, but I would like to know how to do this.
Thank you!
1 Correct answer
Almost... Try this:
var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;
Copy link to clipboard
Copied
Almost... Try this:
var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;
Copy link to clipboard
Copied
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!
Copy link to clipboard
Copied
Make sure you set the field's Format to None for it to work.
Copy link to clipboard
Copied
I changed "Not Commissionable" to "0" and it's formulating exactly how I need it to.
Thank you again for your help!

