How to calculate grand total at the end of form

  • naeemskitchenandbbq
    Asked on May 15, 2021 at 10:41 AM
  • Gaetan_B
    Replied on May 15, 2021 at 12:06 PM

    Hello,

    Thank you for reaching out.


    After checking your form, I think the following article would help you to achieve what you would like to do: https://www.jotform.com/help/275-how-to-pass-a-calculation-to-a-payment-field


    Hope this helps.

    Do not hesitate to reach out if you need further assistance.

  • naeemskitchenandbbq
    Replied on May 15, 2021 at 2:16 PM

    Hi there,

    I added a calculation widget and payment one too. However, when I add several amounts it doesn’t still add it to the calculation. What condition can I use to total everything on the page?

  • John Support Team Lead
    Replied on May 15, 2021 at 4:48 PM

    Allow me some time to check on this and will get back to you here as soon as I found a solution.

  • naeemskitchenandbbq
    Replied on May 15, 2021 at 11:14 PM

    Any luck finding a solution?

  • John Support Team Lead
    Replied on May 16, 2021 at 6:21 AM

    Thank you for waiting! So upon inspecting the form, I can see that you are using conditions to add calculation values into the CALCULATION field:

    1621113648 60a03b306086a  Screenshot 10

    But you also added calculation formula directly into the said field:

    1621113704 60a03b681dad5  Screenshot 21

    Now, when the user selected all products, it will meet all of the conditions, right? And since each condition has its own formula, it will result in condition and calculation conflicts.

    I would suggest adding a number field for each product, assign the calculation values returned by the conditions to it, then just sum up all the number field values in the calculation field.

    Here's an example of how to set it up: https://www.loom.com/share/1b18ce7d83704f0f82e98b3bd8ff5dc9



  • naeemskitchenandbbq
    Replied on May 16, 2021 at 11:42 PM

    ok I will try it out and let you know.

    Thank you