Calculation not working?

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

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.

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

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.

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.