Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Xabinav
		
			Xabinav
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		| CarID | OldCycle | IsRealCycle? | NewCycle (Trying to solve) | 
|---|---|---|---|
| 1234567 | 1 | 1 | 1 | 
| 1234567 | 2 | 0 | 1 | 
| 1234567 | 3 | 0 | 1 | 
| 1234567 | 4 | 1 | 2 | 
| 1234567 | 5 | 0 | 2 | 
| 1234567 | 6 | 1 | 3 | 
| 1234567 | 7 | 1 | 4 | 
Hello everyone,
I'm trying to develop the field "NewCycle".
The logic is that every time that appears "1" in the field "IsRealCycle?" , you need to "Jump" at 1 relative to its previous digit.
Another example...
| CarID | OldCycle | IsRealCycle? | NewCycle (Trying to solve) | 
|---|---|---|---|
| 2222333 | 1 | 1 | 1 | 
| 2222333 | 2 | 0 | 1 | 
| 2222333 | 3 | 0 | 1 | 
| 2222333 | 4 | 0 | 1 | 
| 2222333 | 5 | 1 | 2 | 
Thanks,
 Xabinav
		
			Xabinav
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks Sunny, It's work great !  
