Convert Alpha Dropdown Values to Numeric

  • 20 March 2020
  • 3 replies
  • 4 views
A
Badge +6

Using Nintex Responsive Forms in Sharepoint Online. 

 

I have 10 Questions, all with the same dropdown values (N/A, Meets, Doesn't Meet).

 

At the end of the form, I would like to provide the User with a "Final Score."  Simply, if there are more "Meets" than "Doesn't Meets," then the final score would show "Meets."  Likewise, if there are more "Doesn't Meets" than "Meets," then the final would show "Doesn't Meet."

 

Is there a way to make that happen through Variables/Rules? 

 

Or would I convert each answer to a numeric value?  Meets = 2, N/A = 1, Doean't Meet = 0; and then if it's > 10 = Meets, and < 10 = Doesn't Meet. 

 

Either way, how would I go about doing so?  I can't seem to figure out how to convert the answers to numbers, nor can I think of rules/variables that work.

3 replies

SimonMuntz
Userlevel 6
Badge +22

Hi,

 

I would approach this solution like this.

If they meet they get 1 point.  If they dont meet they get -1 point.  The end result will be a plus or a minus score and zero is a pass. If NA then no points.

 

For each choice control create a variable with a formula that calculates the point based on the choice.

I have named my choice controls A1 to A10 so first variable will look like.

If(equals(A1,"Meets"),1,If(equals(A1,"Doesnt Meet"), -1, 0))

Add a calculated control on the form that adds up the Variables (My varaiables are _A1 to _A10) and outputs Meets or Doesnt Meet based on the result.

If((_A1 +_A2 +_A3 +_A4 +_A5 +_A6 +_A7 +_A8 +_A9 +_A10 )<0,"Doesnt Meet","Meets")

Please find attached the POC responsive form.

I spent about an hour on this so please mark this post as the Accepeted Solution if it fulfills your needs.

 

Cool Nintex courses: https://learn.nintex.com/
A
Badge +6
Thank you for the reply and the work involved.

In the Responsive Designer, I'm not able to use those functions.

Here is my Variable formula: If(equals([Form].[Greeting],"Met Criteria"),1,If(equals([Form].[Greeting],"Needs Improvement"), -1, 0))

And the errors:
Ln 1, Col 1: Function 'If' cannot be found.
Ln 1, Col 4: Function 'equals' cannot be found.
Ln 1, Col 71: Function 'If' cannot be found.
Ln 1, Col 74: Function 'equals' cannot be found.
Formula return type does not match type 'number'.
SimonMuntz
Userlevel 6
Badge +22

Sorry, you said Responsive forms not New Responsive forms.
Create your variables like:
ifElse([Form].[Choice1] == "Meets",1,ifElse([Form].[Choice1]=="Doesnt Meet",-1,0))

6927i33C95865CFFABBC3.png

 

Create another variable that adds all the choice variables up

6928i4CCEE2EDBE967623.png

 

and then use a rule to populate the result field based on the total. ie is it less than zero.

6929i1A17430AB0EB0C79.png

 

see attached New Responsive form for a POC.

Cool Nintex courses: https://learn.nintex.com/

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings