How ot add calculation form "Matrix Field?

  • Profile Image
    CSBRAGA
    Asked on January 22, 2018 at 01: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.



    This is a re-post of a comment on How to Perform Form Calculation in the Matrix Field?

  • Profile Image
    ashwin_d
    Answered on January 22, 2018 at 07: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.gif

    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.

  • Profile Image
    CSBRAGA
    Answered on January 22, 2018 at 08:47 AM

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

  • Profile Image
    CSBRAGA
    Answered on January 22, 2018 at 09:47 AM

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

    UU


  • Profile Image
    ashwin_d
    Answered 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.gif


    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.

  • Profile Image
    CSBRAGA
    Answered 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?

  • Profile Image
    ashwin_d
    Answered 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.