Why calculations are not working in the form?

  • Profile Image
    TheMialeTeam
    Asked on January 16, 2018 at 10:36 AM

    I'm trying to accomplish the following formula, yet it is not calculating correctly, for the field Maximum Allowable Offer:

    (After Repair Value (field) * .70) - (Square Footage (field) * 60)


    Also, for % Difference in list price and MAO:

    (List Price- MAO)/ List Price 


  • Profile Image
    Nik_C
    Answered on January 16, 2018 at 11:44 AM

    I checked your form, the issue is in the formula:

    1516120766Screen Shot 2018-01-16 at 5.37

    When the values in the calculation are light brown, like in the image above, then those values are represented as strings, you can see that in the legend as well on the right-hand side above.

    Also, you had two empty spaces (where the minus sign is).

    I fixed all that in your form.

    The "% Difference" field should work now as well since it is using the value from the "Maximum Allowable Offer" field.

    So please check and let us know how it worked.

    Thank you!

  • Profile Image
    TheMialeTeam
    Answered on January 16, 2018 at 01:08 PM

    SUPER HELPFUL! 

    wow, quick fix, much appreciated!

    Leah