1 Reply Latest reply on Oct 9, 2017 1:22 AM by Bernd Alheit

    Creating if/then condition for complex calculation

    brads5002319

      I have made a calculation for a field:

       

      this.getField("Rental Year 3").value = (this.getField("Rental Year 2").value * (this.getField("Annual Increase").value /100)) + this.getField("Rental Year 2").value;

       

      However, I only want the calculation to apply if another field (Lease Term) has a value greater than or equal to 3. If the value is less than three I would like this field to equal 0.

       

      How do I add this condition?