Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 drohm002
		
			drohm002
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HI,
I have a field, LOS, that contains values 1 through 100. I have another field that is a flag called, CC_FLAG. The values is this field are 0,1, and 2. I want to create a field that sums the LOS field when the CC_FLAG equals 1 or 2. Please help!
 YoussefBelloum
		
			YoussefBelloum
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
you can try this on the script:
table:
load
.
.
if(match(CC_FLAG,'1','2'), LOS) as LOS_count
FROM...
then you can sum it on the front end
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		In the script? Or front end... for front end try this
Sum({<CC_FLAG = {1, 2}>}LOS)
 drohm002
		
			drohm002
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		how about in the script?
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
LOAD Sum(LOS) as SumLOS
Resident ...
Where Match(CC_FLAG, 1, 2);
