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

    Creating if/then condition for complex calculation


      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?