Skip to main content
Nintex Community Menu Bar
Question

Scoring - SharePoint list Nintex Forms

  • February 15, 2023
  • 5 replies
  • 106 views
  • Translate
K
Forum|alt.badge.img+1

Hi everyone, 

I need some help with calculating scores. 

I have a form with 26 categories, each category has about 7-12 choices column with correct and incorrect choice. I would like the scoring to be calculated. User will be doing one category at a time. 

what would the best approach to avoid 300+ rules, as i tried Calculated column within SharePoint but i have hit a limit of number of column reference within the formula. 

this is what i did in SharePoint calculated column but it has reached a limit, so can't use it anymore

TotalCorrect:

+IF(SA1="Correct",1,0)+IF(SA2="Correct",1,0)+IF(SA3="Correct",1,0)+IF(SA4="Correct",1,0)+IF(SA5="Correct",1,0)+IF(SA6="Correct",1,0)+IF(SA7="Correct",1,0)+IF(SA8="Correct",1,0)+IF(SA9="Correct",1,0)+IF(SA10="Correct",1,0)+IF(SA11="Correct",1,0)+IF(SA12="Correct",1,0)


TotalInCorrect:

+IF(SA1="InCorrect",1,0)+IF(SA2="InCorrect",1,0)+IF(SA3="InCorrect",1,0)+IF(SA4="InCorrect",1,0)+IF(SA5="InCorrect",1,0)+IF(SA6="InCorrect",1,0)+IF(SA7="InCorrect",1,0)+IF(SA8="InCorrect",1,0)+IF(SA9="InCorrect",1,0)+IF(SA10="InCorrect",1,0)+IF(SA11="InCorrect",1,0)+IF(SA12="InCorrect",1,0)

Total Score:

=TotalCorrect/(TotalCorrect+TotalNotCorrect)

 

please advise?

Did this topic help you find an answer to your question?

5 replies

MegaJerk
Forum|alt.badge.img+14
  • MegaJerk
  • Scholar
  • 832 replies
  • February 16, 2023

You should just be able to do this using one Calculated Control I’d imagine. Can you provide a few additional details though? 

 

  • Are you using a Classic Form or something else? This is important to know!
     
  • Do the amount of Choice Controls change based on the “category”? If so, are they disabled / enabled based off of the category?
     
  • Do the Choice Controls actually just say “Correct” and “Incorrect” or do they contains answers that are determined to be correct or incorrect via a rule or some other method?
     
  • Can you provide a screenshot of what this looks like?

 

 

Translate
K
Forum|alt.badge.img+1

I am using New Responsive form. It will be a manual selection. the choice does say “Correct” and “Incorrect”. 

 

Translate
MegaJerk
Forum|alt.badge.img+14
  • MegaJerk
  • Scholar
  • 832 replies
  • February 20, 2023

Sorry, one last thing, is this SharePoint online or SharePoint on Prem?

Translate
K
Forum|alt.badge.img+1

Sharepoint online 

Translate
B
Forum|alt.badge.img+8
  • bgarvey
  • Scholar
  • 57 replies
  • February 22, 2023

Simple answer if you wish to use SharePoint calculated columns - split your calculation into 3 columns each covering a 3rd of the IF statements,  Then have a final calculated column that adds up the others, etc.

Like column TotalCorrect would be TotalCorrectPartA+TotalCorrectPartB+TotalCorrectPartC

Column TotalNotCorrect would be TotalInCorrectPartA+TotalInCorrectPartB+TotalInCorrectPartC

And your TotalScore set to =TotalCorrect/(TotalCorrect+TotalNotCorrect) 

Translate
K
1 person likes this
  • K
    Kammasood123

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings