I have built an in-depth evaluation form for my team. It’s connected to our SharePoint site, and on a list, we use the new Nintex form builder. I think we are on the O365 version if that helps.
So, I have several multiple-choice columns, with up to 20 items in each one. I need a way to calculate the percentage of selected boxes from several columns of data. For example, if I have 5 multiple-choice sections, I need to calculate the percentage of all of those choices; we are using them as pass/fail.
Please help.
Answer
Calculate Percentage of Checked boxes
+2Best answer by SimonMuntz
Hi
You have to do a count for each control and then do the calculation.
If I had two multi choice controls with 3 options in each, the rule would look like this:
((count([Form].[Choice multiple 1]))+(count([Form].[Choice multiple 2])))/6*(100/1)
+23- Nintex Employee
Hi
If you want to display this percentage on the form you can use a Label control to display the calculation.
How this is done will depend on the form type being used.
If you are using a New responsive form you would use a formula to add up all the control results.
A controls result would use the formula: (count([Form].[Choice multiple 1])/20)*(100/1) for 20 options.
If you are using a responsive or classic form you would use a calculated control to display the percentage and the calculation for each control would be : (count(choice)/20)*(100/1).
New look Nintex University is HERE: https://learn.nintex.com
+2Thanks for messaging! Here is what I am getting back. Am I making this formula in the right place?
+23- Nintex Employee
Hi
Yes, it's the right place. As the output is a decimal number you need to change the type to decimal. In the image you have it as text.
+2
You got it I had to change it to Integer. The big picture is, I need it to add up multiple multi-choice items, then give a percentage… here is the code I was trying,
(count([Form].[LP 1]+
[Form].[LP 2]+
[Form].[LP 3]+
[Form].[Smith]+
[Form].[Ergonomics PreTrip]+
[Form].[Ergonomics Loading]+
[Form].[Ergonomics Unloading])/52)*(100/1)
Looking for what I am doing wrong here, I’m not coder…
+23- Nintex Employee
- Answer
Hi
You have to do a count for each control and then do the calculation.
If I had two multi choice controls with 3 options in each, the rule would look like this:
((count([Form].[Choice multiple 1]))+(count([Form].[Choice multiple 2])))/6*(100/1)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.