- TheMialeTeamAsked 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
- JotForm SupportNik_CAnswered on January 16, 2018 at 11:44 AM
I checked your form, the issue is in the formula:
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.
- TheMialeTeamAnswered on January 16, 2018 at 01:08 PM
wow, quick fix, much appreciated!