My form calculation is not working properly

  • Profile Image
    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?

  • Profile Image
    Welvin
    Answered 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.png

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

  • Profile Image
    Welvin
    Answered 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:

    This is to correct the calculation once users changes selections. 

  • Profile Image
    Welvin
    Answered 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? 

  • Profile Image
    sstte18
    Answered on November 15, 2018 at 01: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)

  • Profile Image
    Richie_P
    Answered on November 15, 2018 at 03: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:

    then you combine the credit with the total attending.

    Here is a sample screen cast:

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

  • Profile Image
    sstte18
    Answered on November 15, 2018 at 08: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

  • Profile Image
    BJoanna
    Answered on November 16, 2018 at 03: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.