## Browse Article by Topics

matrix field form calculation matrix calculation## Related Articles

- How to Perform Form Calculation Using a Widget
- How to Perform Form Calculation in the Matrix Field?
- Calculate Values in the Input Table Through Condition

## Related Forum Questions

- Can we set form calculation as read only
- Form Calculation Widget: Ability to clone widget keeping the calculation formula.
- Why many of my formulas from the "Form Calculation Widget" have dissappeared?
- My JotForm price calculation keeps on resetting after form submission?
- New form layout: Form Calculation Widget does not reflect the result to the spreadsheet, autoresponder and notification
- New Layout: Calculation value is not saved on submission
- Form calculation with inventory widget is not working correctly
- not able to see Form calculation option like :total score and percentage
- How to calculate a discount using Form calculation widget?
- How to create score calculation in form?

# How to Perform Form Calculation in the Matrix Field?

**Last Update: May 7, 2017**

It is now possible to use the Matrix field to perform form calculation.

Here in our example, we will set the matrix field similar to a survey questionnaire with ratings or value on them, we will calculate the total rating using the Form Calculation widget. You can follow the steps below on how to do that.

In Version 4.0, we call the Matrix Table from Version 3.0, **Input Table**. It can be found in the ** Quick Elements** section of the

**tab when you add**

*Basic***to the form.**

*Form Elements*Once you've added the **Input Table**, __select an input type from its properties__ (*cogwheel icon*). From the same ** Fields** tab of the Input Table properties, you will be able to set row and column headers.

After constructing the table, you now need to __set calculation values for each of its cell__ (matrix sub-field). To do that, go to the **Options** tab and __enter the values in the provided text area for calculation values__ following this simple rule, "* Separate each column with a comma and each row with a new line.*"

In the example above, __4 Rows means 4 lines__ and __4 columns means 4 values separated by a comma__.

** Note:** Choosing a different input type for the table, like a

*text box or number text box*, if you want your respondents to define values for each cell, will not require you to set calculation values.

To get the total value of the selected cell(s) on the table, you will use the **Form Calculation widget** from the ** Widgets** tab when you add

**to the form.**

*Form Elements*To perform the calculation, you need to __add the input table to the calculation area of the Form Calculation widget__.

Clicking the "** Add Field**" button shown in the screenshot above lets you add fields to the computation.

Adding an Input Table field will let you __select which row (radio button) or cell (checkbox field) in the table is to be included in the computation__. (*This is also referred as matrix sub-fields.*)

After selecting the matrix sub-field(s) and clicking **Done**, you will see the selected sub-fields of the input table in the calculation area of the Form Calculation widget. From there, you will be able to __create your own formula to get a total value__. The calculation pad on the right will surely help you with the simple to complex mathematical tasks.

Sample Form that you can also clone to your account for testing: https://www.jotform.com/form/70984576350970

Other references that might be helpful:

Form Calculation - Math Function Reference

How to Perform Form Calculation Using a Widget

You can check the sample form here: http://form.jotformpro.com/form/51691444490963?

Do you have questions about this guide? Please let us know in the comment box below or post it to support forum.

## 13 Comments... |

events296 |
(June 29, 2015 at 10:51 AM) | ||

I have tried to output the sum of a matrix's fields multiple times. Every time I save the logic the fields are removed and all I am left with in my equations is the addition signs. |

Communicaid |
(March 04, 2016 at 06:14 AM) | ||

Hello, |

Communicaid |
(March 04, 2016 at 10:52 AM) | ||

ok, thank you for your help |

IDOEWebmaster |
(June 22, 2016 at 10:54 AM) | ||

How do I multiply the value of column 1 and column 2 and show the result value in the column 3 of the matrix table? |

jannyfer.chua |
(August 05, 2016 at 04:22 AM) | ||

Hi, I have a set of 28 questions and 5 radio columns (Never, Rarely, Sometimes, Very often, Always). a) How do I set values for each column and when they are selected, the values are added up? e.g. Never=1, Rarely=2, Sometimes=3, Veryoften=4, Always=5 if Never is selectedx2, rarely x1, always x2 = the total is 14. b) How do I set the 28 questions to calculate 4 different totals from the above columns. eg. Qs 1-7, 8-14, 15-21, 22-28 and then set a formula to only show the results for the highest total? |

aysaquing |
(August 15, 2016 at 04:48 AM) | ||

Can I set condition on form matrix calculation? For example if column 5 as remarks says Best, the calculator will just compute all fields (rows) with best. Is that possible? Thanks. |

poudreriver |
(December 16, 2016 at 12:50 PM) | ||

I am trying to count how many checkboxes are checked in a matrix. |

ZacharyRichards |
(January 26, 2017 at 08:35 PM) | ||

I wanted to know if it were possible to create a calculation in the actual matrix. |

AlfaIndoJaktim |
(February 27, 2017 at 11:21 PM) | ||

if i set input type to numeric text box, can i get the result from the form calculation? |

lansingparty |
(February 28, 2017 at 03:13 AM) | ||

I am hoping to get some help here because I am sure this is possible and I am simply missing how to do this. This is a limo company with a few variables. Lets make it simple and say we have limoA, limoB, and limoC. Each of these limos have an hourly rate for Weekday, Friday, Saturday. How would I set this up so the customer could fill out the form select the day of the week, use a check box form to select what they want quotes on, then depending on the hours selected multiply the value by the hours? |

KPWM |
(March 21, 2017 at 01:52 PM) | ||

I want to assign values to each question in my matrix, but I don't want the person filling out the form to see the value. I only want to be able to see it. Is this possible? |

FifteenAndFifteen |
(May 22, 2017 at 01:50 PM) | ||

How can I delete a field and add a different field from the add field button? |

MummySOSLtd |
(July 10, 2017 at 05:47 PM) | ||

Can I make it so that each drop down option can only be used once? |

## Send Comment