My form calculation is not working properly

  • sstte18
    Asked on November 15, 2018 at 10:38 AM

    I can't figure out why this calculation is not working properly. I have tried "is not equal to" value 0 and "does not contain" value 0 in the conditions but once someone enters 0, it zeros out the total. 

    It's supposed to add $36 * additional # of guests if the total is NOT zero.

    Can you help?

  • Welvin Support Team Lead
    Replied on November 15, 2018 at 12:38 PM

    You do not need conditional logic as far as I understand the calculation. You can get the value by calculating fields directly.

    1. Add Calculation Value for the field "Would you like to sponsor this event?"

    Guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value.

    2. Get the total by this formula:

    15423035142018 11 16 006 Screenshot 10

    Here's a cloned version of your form showing this changes: https://form.jotform.com/83185059982974.

  • Welvin Support Team Lead
    Replied on November 15, 2018 at 12:41 PM

    By the way, make sure to set Clear Hidden Field Values to Clear on Being Hidden in the Form Settings:

    My form calculation is not working properly Image 1 Screenshot 20

    This is to correct the calculation once users changes selections. 

  • Welvin Support Team Lead
    Replied on November 15, 2018 at 12:46 PM

    I just realized that the calculation may be incorrect. Please clarify how the surcharge of 1.03 is calculated. Is that after getting the sum of "Would you like to sponsor this event?" field and the additional person? 

  • sstte18
    Replied on November 15, 2018 at 1:05 PM

    it should be that if they select yes to either sponsorship - it would be 1.03 * (that amount  * plus ($36 * number of additional guests).  the problem was coming in when the number of additional guests equaled 0.  it zeroed everythign out.


    if they select "not at this time" then it's just 1.03 * (number of people attending * 36)

  • Richie JotForm Support
    Replied on November 15, 2018 at 3:35 PM

    You may try to separate each calculation for your total credit and attending guest.

    Then combine the total after each calculation,so that you don't need to use conditions.

    For total attending:

    My form calculation is not working properly Image 1 Screenshot 40

    then you combine the credit with the total attending.

    My form calculation is not working properly Image 2 Screenshot 51

    Here is a sample screen cast:

    My form calculation is not working properly Image 3 Screenshot 62

    Please give it a try and let us know if you have further questions.

  • sstte18
    Replied on November 15, 2018 at 8:41 PM

    I had to add other conditions to this form so that people could select their method of payment.  Do you think this form is working properly?  It seems to be but can you review it before I copy over all the conditions to the old form which is live?  This is a cloned form...

    https://form.jotform.com/83184705420150

  • BJoanna
    Replied on November 16, 2018 at 3:17 AM

    I inspected and tested your form and as far as I can see it is working properly. 

    I would suggest you to test it a few times more just to be sure.