Input table calculation not working as expected

  • lpcamjform
    Asked on August 8, 2020 at 10:04 AM

    Noticed when I was adding product list up the last product didn't add to the total, ive got

    Product 1 +

    Product 2 +

    .....

    Product 20+

    Procut 21

    I thought it was becuase I didn't have a + on the last product but the operator from the previous is to add the next one so shouldn't need it. I added the + at the end and the 0 disappeared from the calculation field and a huge number appeared in the field like this 23000000e

    I removed the + at the end and it fixed the addition but the last one didn't add still. Any thoughts?

  • John Support Team Lead
    Replied on August 8, 2020 at 10:45 AM

    If this is the form you're working on with: 1:1 Product Order Form, it seems you have deleted the FORM CALCULATION field. So I tried cloning it and added a form calculation widget at the bottom and follow the guide on How-to-Perform-Form-Calculation-Using-a-Widget.

    Input table calculation not working as expected Image 10

    Here's the form: https://form.jotform.com/202203830519951 

    As you can see, the calculation is working as expected. 

    Please ensure that each field is separated with a "plus" sign. If you missed adding one, that should impact the result of the calculation.