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.


  • Profile Image

    Calculation not working?

    Asked by isbitt on January 26, 2016 at 11:16 AM

    Hi,

    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

    Screenshot
    thanks calculation fields work correct
  • Profile Image

    Answered by victor on January 26, 2016 at 02:30 PM

    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.

  • Profile Image

    Answered by isbitt on January 27, 2016 at 07:13 AM

    Hi,

    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

    thanks

  • Profile Image

    Answered by victor on January 27, 2016 at 09:04 AM

    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.

    https://form.jotform.com/60263530073951

    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.

  • Profile Image

    Answered by isbitt on January 27, 2016 at 10:49 AM

    Many thanks Victor

    I have amended my formula as suggested and it works perfectly.  Many thanks for your help

  • Profile Image
    JotForm Support

    Answered by BJoanna on January 27, 2016 at 12:59 PM

    On behalf of my colleague, you are welcome.

    Feel free to contact us if you have any other questions.