Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi Friends,
I want to show the Days between 2 status (from below sample data).
Ex: for Status = 2, the days should be difference between min(Date) for Status = 2 and min(Date) for status = 3 (Which is next status to 2)
I thought the below formula would work but it is giving days between same status (say for status =2, I am getting days as 7)
NetWorkDays(min(Date), max(Date))
| Contract | Date | Status | 
| 2 | 2/24/2015 | 2 | 
| 2 | 2/18/2015 | 2 | 
| 2 | 2/23/2015 | 2 | 
| 2 | 2/24/2015 | 2 | 
| 2 | 3/6/2015 | 3 | 
Any help will be appreciated.
 
					
				
		
 miguelbraga
		
			miguelbraga
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Anjan,
Why don't you use set analysis like this:
=min({$<Status = {'2'}> Date} ) - min({$<Status = {'3'}>} Date)
Regards,
MB
 
					
				
		
 Mark_Little
		
			Mark_Little
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Give the below a try,
=NetWorkDays(Max({<Status={2}>}Date) ,Min({<Status={3}>}Date))
Mark
 
					
				
		
Hi Miguel and Mark,
I just gave a subset of data. Actually my data has 1 to 10 status and my expression has to get the Days between status in the above specified way.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		So you want to get difference between starting days for each of the statuses??? Do you only have information about a single contract? or do you have multiple contracts and each have 1 to 10 statuses?
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		PFA

