How ot add calculation form "Matrix Field?

  • CSBRAGA
    Asked on January 22, 2018 at 1:32 AM

    I'm trying to total a column using the Form Calculation Widget and I don't know what I'm doing wrong.

    I can't seem to get the + sign after the added field and then the numbers are calculating higher than they actually are. I put in 10 and 10,000 is showing up in the calculation field.

  • Ashwin JotForm Support
    Replied on January 22, 2018 at 7:59 AM

    Do you want to show the sum of all "Total Cost" column? Please note that you can select all the fields of column and then manually add "+" sign in the form calculation widget. Please check the screenshot below:

    1516624977formCalc Screenshot 10

    Please check the following cloned form and see if this works as expected:   https://form.jotform.com/80213709804958 Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Do get back to us if you need any other changes.

  • CSBRAGA
    Replied on January 22, 2018 at 8:47 AM

    I did exactly that but it won't let me put the + sign next to each item, it goes onto another line?

  • CSBRAGA
    Replied on January 22, 2018 at 9:47 AM

    should I use a configurable list instead?   and in that list can you do calculations?   how many units

    UU


  • Ashwin JotForm Support
    Replied on January 22, 2018 at 11:16 AM

    That should be fine. It appears that it is going to new line (maybe because of screen resolution) but as long as the "+" is added between two fields, you should not have any issue.

    I did check the second form calculation widget (PO) and you seems to have added it correctly. Please check the screenshot below:

    1516637699matrixCals Screenshot 10


    If you continue to have issues, please let us know how you want the calculation to be and we will help you with the formula for calculation.

    We will wait for your response.

  • CSBRAGA
    Replied on January 22, 2018 at 11:30 AM

    Is there a way to use Configurable List and add a calculation to the Total Cost column?

  • Ashwin JotForm Support
    Replied on January 22, 2018 at 12:08 PM

    Unfortunately no. It is not possible to use "Configurable List" widget with form calculation. Have you checked our "Spreadsheet" widget already? Please try it out and see if it fits into your requirement. This will allow you to do add calculation formula with in cells of the widget.

    Hope this helps.

    Do get back to us if you have any questions.