## 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?
- How to Perform Calculation in the Matrix Field Through Condition

## Related Forum Questions

- Cannot update new calculation formula for Form Calculation Widget
- Form Calculation "brown comma" instead of "black comma"
- Testing whether a Form Calculation result is an integer
- Preventing Negative Values in Form Calculation Widget
- Issue with Calculation Conditions
- One of our field is calculating as 60 instead of just 6
- How to conditionally show/hide a field based on the quantity that is selected in a payment field?
- Stripe form calculations
- Problem with widget form calculation.
- Form Calculation Widget

# How to Perform Form Calculation in the Matrix Field?

**Last Update: January 29, 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.

**How to Set Calculation Values For Checkbox and Radio Input Type**

*If you want user defined values, you can use text box input type and skip to step 4.*

1. Add the matrix field by dragging it in your form.

2. Open the matrix field properties, go to Options tab then enter the calculation values like the following.

3. To get the total, add a Form Calculation widget in your form

4. In the “Calculation window”, click the “Add Field” button to add the fields you want to fetch the value from, in this case it’s the Matrix field.

5. Choose the Matrix Field based from the label you used.

6. Choose what rows you want to fetch the values.

7. You can then use different math functions or values to perform your calculation. In my case, I want to add all the selected radio buttons to have the total score of the survey questionnaire.

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.

## 8 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. |

## Send Comment