Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 jduenyas
		
			jduenyas
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all
Is there a TREND function, except for the visual linear trend line in the Expression tab, which will tell me if a trend is positive or negative over a given period?
If a trend is negative over 3 (or 4, or 5) months I would like to show a red arrow pointing down or green arrow pointing sideways or up depending on the trend direction.
Thanks
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		search for
linest_m()
regards
Marco
 
					
				
		
 jduenyas
		
			jduenyas
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks Marco
It may help
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
one example using this function:
hope this helps
regards
Marco
 
					
				
		
 jduenyas
		
			jduenyas
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Exactly what I was looking for!
Thanks Marco
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you're welcome
regards
Marco
