Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 pranubitla
		
			pranubitla
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Dear Experts, could any one help with my attached script error. all i am trying to do apply color coading based on percentage  levels for 
"Early arrears" and  "late arrears" ,
Details: Straight table dimention is "Arrearsprofile" , expression is sum(Current balance)
Backend script Dimension caluculated like this 
  IF (ArrearsBand > 0 AND ArrearsBand <=3 ,'Early Arrears',
    IF (ArrearsBand >3 ,'Late Arrears',)) AS   'ArrearsProfile',   
 
					
				
		
 pranubitla
		
			pranubitla
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Many thanks Anil and Vineeth, got the result. 🙂
 
					
				
		
 vinieme12
		
			vinieme12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, i've modified the expression in post above, try and check this should be all you need
 
					
				
		
 pranubitla
		
			pranubitla
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks for you help Vineeth
