- Thank you received: 0
 
Adding up colums, including rubric columns
- james.me.robinson
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        
			
    
						6 years 8 months ago		        #7970
        by james.me.robinson
    
    
        
			
										        
    
			Adding up colums, including rubric columns was created by james.me.robinson        
        
			Hi Bert,
I am trying to calculate the total addition over several columns, including some rubric totals. At the moment, the rubric column is showing 36/36, however when the addition column takes this into account, it is counting this as 1 rather than as 36. Is there a way to get around this?
		    I am trying to calculate the total addition over several columns, including some rubric totals. At the moment, the rubric column is showing 36/36, however when the addition column takes this into account, it is counting this as 1 rather than as 36. Is there a way to get around this?
- bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						6 years 8 months ago		 -  6 years 8 months ago        #7971
        by bert
    
    
        
    
    
			Replied by bert on topic Adding up colums, including rubric columns        
        
			Hello James,
If you use the 'Percentage over total addition' option in 'Addition', the rubric's total points will be shown instead.
If you use a simple formula (add column > calculation > formula) and use the RAW function it will take into account those points instead of the fraction.
It would look like this
COLUMN1 + COLUMN2 + RAW(RUBRIC) + COLUMN3
		    If you use the 'Percentage over total addition' option in 'Addition', the rubric's total points will be shown instead.
If you use a simple formula (add column > calculation > formula) and use the RAW function it will take into account those points instead of the fraction.
It would look like this
COLUMN1 + COLUMN2 + RAW(RUBRIC) + COLUMN3
		Last edit: 6 years 8 months ago  by bert.		    
    
		The following user(s) said Thank You: james.me.robinson     
			
										        - james.me.robinson
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 0
 
			
    
						6 years 8 months ago		        #7972
        by james.me.robinson
    
    
        
			
										        
    
			Replied by james.me.robinson on topic Adding up colums, including rubric columns        
        
			Thanks Bert. All sorted! Much appreciated.