Basic formula not calculating. Not sure why.

  • wolfpaw69
    Asked on December 15, 2015 at 5:12 PM

    I've got a formula that charges more for homes as they get older. When I get to 2011 or newer, its not calculating correctly.  It should be 0 but returns 150, the same for extremely older homes.  Not sure why.  Can you help?

    Jotform Thread 726150 Screenshot
    Page URL: https://form.jotform.com/53127112452141?
  • Kevin Support Team Lead
    Replied on December 15, 2015 at 7:16 PM

    Hi,

    I have checked your form and I can see you have some conditions that are not working, I would suggest you to delete them or disable in order to avoid issues :

    Basic formula not calculating Screenshot 30

    Also , I could fin the condition that is adding the value to your field, disable it and try to fill the field with the 2011 year, I would suggest you to change it in order to not affect another conditions.

    Basic formula not calculating Screenshot 41

    Please, let us know if it works.

    Regards.

  • wolfpaw69
    Replied on December 24, 2015 at 2:30 PM

    I disable that calculation and it still returns $150

  • wolfpaw69
    Replied on December 24, 2015 at 2:33 PM

    I actually deleted the line of code that produces $150 and I still get a $50 result.  It there a time delay between saving and viewing?

  • BJoanna
    Replied on December 24, 2015 at 4:00 PM

    It seems that you were able to resolve this issue. I have tested your form and when I entered 2011 in Year Built field I got a $0 result in Age Cost field.

    Basic formula not calculating Screenshot 20

    Yes, sometimes there is a delay between saving and viewing. In that case you can reload your form of log out and log back in to your account. 

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

  • wolfpaw69
    Replied on December 24, 2015 at 6:57 PM

    Still happening...this was taken just a few minutes ago.  I do see yours returned a $0.  This is in google.  I'll have to try IE

    Basic formula not calculating Screenshot 20

  • BJoanna
    Replied on December 25, 2015 at 2:32 AM

    I have tested form you provided http://www.jotform.us/form/53127112452141, one more time and I was not able to replicate mentioned issue. 

    However from screenshot you provided, I think that you are working on your other form http://www.jotform.us/form/53564138647160, on which I was able to replicate mentioned issue. 

    Basic formula not calculating Screenshot 30

    To fix this you need to follow steps provided by my colleague Kevin_G and disable or delete conditions for fields that are deleted form your form and to delete or disable condition 84, which is passing value 150 to your Age Cost field. 

    Basic formula not calculating Screenshot 41

    I have cloned your form http://www.jotform.us/form/53564138647160 and disabled mentioned conditions on my cloned form. Here is my cloned form: https://form.jotform.com/53580777124965 

    Feel free to clone it.

    Hope this will help. Let us know if you need further assistance.