Field values getting concatenated instead of totalled

  • gradelink
    Asked on July 13, 2017 at 2:32 PM

    One section of our survey correctly totals the field values; the second section is build the same way with the same conditions, but instead of totalling (e.g. 25+25=50), it concatenates them ("2525"). What are we doing wrong?

    Jotform Thread 1198634 Screenshot
    Page URL: https://form.jotformpro.com/71925985679984
  • Mike_G JotForm Support
    Replied on July 13, 2017 at 3:53 PM

    As mentioned in Step 3.1 of this guide — Conditional-Logic-Inserts-Text-Calculation-Into-A-Field, to represent the numeric value of the fields being added, please make sure that the fields are set to "0-9" in the calculation area of conditions. To fix the issue you are having in your form, please refer to the screenshot below.

    Field values getting concatenated instead of totalled Image 1 Screenshot 30

    As for getting the average, please see the #1 of Other Math Functions of this guide — Form-Calculation-Math-Function-Reference

    To get the average of multiple field values, separate each field inside avg (), with a comma.

    Field values getting concatenated instead of totalled Image 2 Screenshot 41

    I hope this helps. If you have other questions regarding this, please feel free to contact us again anytime.

  • gradelink
    Replied on July 14, 2017 at 5:40 PM

    Thank you so much. It's working.