Community
        
        
            
                
                    Good morning,
I seem to have a problem with the addition of scores on my forms. All forms are the same (they are just used in different areas in the business). 
  
I have just completed a test form and the results are attached in a pdf. I answered all questions with a one (for ease of addition) so the final score should have been 25, but for some reason it is giving me a total of 26. This is happening on all my forms - the final score is always one more than it should be. I have checked the addition in the backend and it all seems correct, so I'm confused as to why it's not working properly. Can you help me please?
Kind regards
Amanda Wells
                    
                 
                
             
         
     
    
        
        
     
Comments (1)
Jul 22, 2024
Hi Amanda, when you use the SCORE function to assign points and calculate scores, it will assign the points for all the multiple choice, checkboxes and grid questions. You have used the SCORE(SECTION, 1, 2, 3) formula to assign the points and calculate the section scores for the 5 sections in your form. Each of these sections has one grid question, a paragraph question for comments and a short answer question with the formula for the section score. These section scores are calculated correctly. You have used the SCORE(ALL, 1, 2, 3) formula to calculate the overall score. This formula assigns the points for each of the grid questions in the 5 sections as well as the multiple choice question "Type of Audit" in the home page. If you don't want to include the "Type of Audit" multiple choice question in the score calculations, then you can use the SUM function to add the 5 section scores instead of the SCORE function. SUM( section#1, section#2, section#3, section#4, section#5 ) where section#1, section#2, section#3, section#4, section#5 are the short questions you want to add to calculate the overall score. You must type @ and select the required field from the list to include them in the formula above. In the Edit page, click on the gear icon next to the total score question > Question settings page will be displayed > click Answer > enter the above SUM formula in the Calculate option and click Save.
Add your comment
Add photo