I have to determine the delay between 2 type, but these date are in the same row named creation date.
For example I have to know the delay between P40 and P91 or above. For this I use the NetWorkDays function and it work well when I'm working with the delay from the first date to the creation date. I wrote this :
Avg(NetWorkDays([first_date],if(type='P91' or type='P92'or type='P93'or type='P98',[creation date])))
Here I want the average delay from the first date to the finalisation of a contract which correpond to P91 and above from the creation date. And it's work fine
the problem is when I only use the creation date to determine the delay between P40 and P91 and above it doesn't work because I'm working in the same row.
Avg(NetWorkDays(if(type='P40',[creation date]),if(type='P91' or type='P92'or type='P93'or type='P98',[creation date])))
This display any data. If someone have some idea how it can work, that would be great