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.
Hi Anjan,
Why don't you use set analysis like this:
=min({$<Status = {'2'}> Date} ) - min({$<Status = {'3'}>} Date)
Regards,
MB
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.
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?
PFA