Calculation not working properly on form

  • sstte18
    Asked on January 23, 2018 at 3:40 PM

    Please help me finalize this form.  The check/credit card totals are not calculating properly.  I think it's b/c I need to add the calculate field condition for the journal ad field and the tax deductible donation field but it's not giving me the right options when I try to add it.  Can you help?

  • jonathan
    Replied on January 23, 2018 at 4:53 PM

    Can you tell as what should be the correct calculation?

    I test your form with the following data

    1

    1

    $90

    $54

    and I got the following result for check or credit calculation.

    1516744299zzz 2018 01 24 05 Screenshot 10

    Credit Card:

    1516744332zzz 2018 01 24 05 Screenshot 21


    from my test so far, it seems the calculation is working.

    We will wait for your updated response.


  • Melanie
    Replied on January 23, 2018 at 5:14 PM

    That total isnt right. It should be $145 x number attending plus $100 x number of raffles plus Journal ad choice plus tax deductible donation choice. Any of these 4 choices could be left blank. 

  • jonathan
    Replied on January 23, 2018 at 5:46 PM

    Thank you for the explanation. Let me review further the calculations.

    I will update you shortly.

  • jonathan
    Replied on January 23, 2018 at 6:01 PM

    Please review the Calculation formula for the Credit Card Total.

    It has a different formula and it seems to be missing a closing bracket ")" 


    1516748399zzz 2018 01 24 06 Screenshot 10


    The Check Total has a correct calculation formula and is working as intended.

    1516748463zzz 2018 01 24 06 Screenshot 21


    Let us know if still not resolve.



  • sstte18
    Replied on January 23, 2018 at 6:10 PM

    not working at all.  If I select 1 person going, 1 raffle ticket and $1000 for each of the next 2 choices (journal ad and tax deductible donation), the total should be $2,245.  Its $30,000+!!!  Big difference.

  • jonathan
    Replied on January 23, 2018 at 6:20 PM

    Can you please share to us what is the correct formula for Credit Card Total.

    We can do a test with a fresh formula on the test form. We just need to understand first what is the correct calculation formula.



  • sstte18
    Replied on January 23, 2018 at 6:37 PM

    I sent the formula previously. It’s number of people attending x $145 plus number of raffles x $100 plus Journal ad selection plus tax deductible Donation selection. Total x 1.03%

  • Mike
    Replied on January 23, 2018 at 7:58 PM

    When you provide the calculation values, the additional multiplication in the calculation formula is not required.

    Calculation not working properly on form Image 1 Screenshot 40

    I have updated the formulas on your form.

    Calculation not working properly on form Image 2 Screenshot 51

    Calculation not working properly on form Image 3 Screenshot 62

    Please re-check the form now. Thank you.

  • Melanie
    Replied on January 23, 2018 at 8:03 PM

    Umm. This doesn’t make sense bc how does the form know that the first two fields r valued at $145 and $100?

  • Elton Support Team Lead
    Replied on January 24, 2018 at 2:11 AM

    Those are automatically fetched from the field calculation value so there's no need to define it twice.

    Example: If the user selects 2 Adults, it is not 2 that will be passed in the calculation, it is the 290

    Calculation not working properly on form Image 1 Screenshot 20

  • Melanie
    Replied on January 24, 2018 at 6:38 AM

    Thx. Did u add those values?  I didn’t know those were there. It works now. 

  • Mike_G JotForm Support
    Replied on January 24, 2018 at 10:38 AM

    Based on the conversation above, it seems that the Calculation Values of the field were already set even before we assisted you in this thread. Nevertheless, we are glad to know that the form now works on your end and we appreciate you giving us an update.