Days between

[#1]

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]

Hi Anjan,

Why don't you use set analysis like this:

=min({$<Status = {'2'}> Date} ) - min({$<Status = {'3'}>} Date)

Regards,

MB

[Mark_Little]

Hi,

Give the below a try,

=NetWorkDays(Max({<Status={2}>}Date) ,Min({<Status={3}>}Date))

Mark

[#4]

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]

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]

PFA