Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 tmumaw
		
			tmumaw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Any idea what is wrong with this expression? I keep getting error in expression.
Thanks
if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
 if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#),RGB(255,0,0)),RGB(0,0,0)))  
 
					
				
		
 tmumaw
		
			tmumaw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Got it.....
if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
 if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#))),RGB(255,0,0),RGB(0,0,0)))  
 
					
				
		
 tmumaw
		
			tmumaw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Got it.....
if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
 if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#))),RGB(255,0,0),RGB(0,0,0)))  
 buzzy996
		
			buzzy996
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		try this,
=if(Sum(UnKnown_Cnt) / count(Empl.#) < 0.20,RGB(0,0,255),
if((Sum(UnKnown_Cnt) / count(Empl.#) ) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#),RGB(255,0,0)),RGB(0,0,0))
check bracket pls.
