Skip to main content
masonb77741322
masonb77741322
Participating Frequently
April 30, 2019
Answered

IF Function with Less Than Values

  • April 30, 2019
  • 1 reply
  • 606 views

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!

This topic has been closed for replies.
Correct answer try67

Almost... Try this:

var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
April 30, 2019

Almost... Try this:

var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;
    masonb77741322
    masonb77741322Author
    Participating Frequently
    April 30, 2019

    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!

    try67
    Community Expert
    try67Community Expert
    Community Expert
    April 30, 2019

    Make sure you set the field's Format to None for it to work.

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