What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Calculation not working?Asked by isbitt on January 26, 2016 at 11:16 AM
It seems 2 of my calculation fields no longer work. Would you mind reviewing for me
These are the 2 'partial' calculation net loss fields that are returning a blank value even though the calculation seems correct
thanks calculation fields work correct
Sorry for the inconvenience. I just cloned your form and was able to view the issue you are having. I am nor really sure why it is not working, but when I removed and re-created the field, the calculation was working properly.
Please let us know if replacing the field solve the issue.
The problem is that I have show/hide conditions assigned to these fields based on selection criteria on other fields. So if I delete and re-add I will need to find the condition fields again and re-do it
If there is no other way then i'll spend time re-doing it, but ideally this is serving a user base of 40+ so it would be great if the calculations worked without re-doing it
Thank you for the update, I have just reviewed your form and did a little more testing. After playing around with the calculation I was able to make the formula work. You may clone the form so you may analyze the and use it you like.
In your formula I recommend modifying it by placing the MINUS sign in front of the formula instead of trying to multiple by a negative one (-1).
I also noticed that there are many fields with the same name. When selecting the field to use, please verify that it is the correct one.
If you require further assistance, please let us know.
Many thanks Victor
I have amended my formula as suggested and it works perfectly. Many thanks for your help
On behalf of my colleague, you are welcome.
Feel free to contact us if you have any other questions.