+2So I have a new calculation that I need to display in Nintex Forms. I have about 15 choice questions, each has the same 4 options. Satisfactory, Needs Improvement, Unsatisfactory and N/A. I want to add up the Satisfactory selections and display them as a percentage. For example, If I had 10 questions, and 5 were selected as Satisfactory the percent displayed would be 50%.
How do I create that variable?
Best answer by bamaeric
Below is how you can do this with two form variables. You could probably do this with just one variable, but I did not want to overcomplicate it.
Form Variable 1:
Form Variable 2:
If you would like, you can add a Label control to the form and insert the decSatPercent form variable (along with a fixed % sign) to display the percentage.
+13Which forms designer (Classic, Responsive, or New Responsive) are you using?
+13Below is how you can do this with two form variables. You could probably do this with just one variable, but I did not want to overcomplicate it.
Form Variable 1:
Form Variable 2:
If you would like, you can add a Label control to the form and insert the decSatPercent form variable (along with a fixed % sign) to display the percentage.
+2That worked great! Thank you. One last thing, I understand how to display the number in a label, how do I put it into a field that will be saved to the Sharepoint list?
+13Glad I could help. Below are steps to save the percentage in a list column.
+2Quick Question, Now they are asking for it to count N/A as well. How do I need to tweak the formula to include “Satisfactory and N/A”?
+13What I would to avoid the first formula getting too complicated is create a second form variable of type integer to sum up the “N/A” choices. All you would need to do is copy the formula for the “Satisfactory” variable, then replace the “Satisfactory” parameter with the “N/A” choice. This formula would look like this:
sum(ifElse(contains([Form].[Choice1],"N/A"),1,0),ifElse(contains([Form].[Choice2],"N/A"),1,0),ifElse(contains([Form].[Choice3],"N/A"),1,0),ifElse(contains([Form].[Choice4],"N/A"),1,0),...)
Next create another integer form variable to sum up the other two choices variables. That formula would look like this:
[Form].[intChoicesSatCount] + [Form].[intChoicesNACount]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.