- Thank you received: 3
 
Grade column based on points column?
- pauhana658
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        
			
    
						3 years 9 months ago		 -  3 years 9 months ago        #10223
        by pauhana658
    
    
        
    
    
    
    
			Grade column based on points column? was created by pauhana658        
        
			I have a Total Points column. I want to create a Grade column based on the Total Points column. I have created a text-based Grade Type and I have created a Weighted Average calculation in the Grade column based on the Total Points column.
It doesn't work. No matter what the number in the Total Points column, the Grade is "F". Is there a way to base a text Grade in one column on a numeric value in another column?
        
		    It doesn't work. No matter what the number in the Total Points column, the Grade is "F". Is there a way to base a text Grade in one column on a numeric value in another column?
		Last edit: 3 years 9 months ago  by pauhana658.		    
			
										        - bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						3 years 9 months ago		        #10231
        by bert
    
    
        
    
    
			Replied by bert on topic Grade column based on points column?        
        
			It works but only if properly configured.
The 'Total points' column is most likely wrong. Make sure the grade type is set to generic and its 'Max points' is properly set.
I'm assuming the Grade column is set to 100% of 'Total points' already
		    The 'Total points' column is most likely wrong. Make sure the grade type is set to generic and its 'Max points' is properly set.
I'm assuming the Grade column is set to 100% of 'Total points' already
		The following user(s) said Thank You: pauhana658     
			
										        - pauhana658
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 3
 
			
    
						3 years 9 months ago		        #10235
        by pauhana658
    
    
        
			
										        
    
			Replied by pauhana658 on topic Grade column based on points column?        
        
			Yep, that works! And yep, the problem was the Total Points column was not set to generic. Thanks!