Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i need to calculate delay between two dates working days.
data:
Date1 = 01/01/2021 | dimension1 | n°invoice
Date1 = 13/02/2021 | dimension2 | n°invoice
how to calculate delay, i have try this but not working :
variable :
vDate1=if(dimension1=1,Date1)
vDate2=if(dimension=2,Date1)
formule:
Avg({ <Date1={">=$(=Min(Date_Calendar))<=$(=Max(Date_Calendar))"}>} (networkdays (vDate1,vDate2)-1))
anyone can help me ?
Hi @squalitooo Have you checked this post which has a great solution to your question
Working Hours Calculation excluding weekends and holidays
Let me know if this helps.
Thanks
Hi @squalitooo Have you checked this post which has a great solution to your question
Working Hours Calculation excluding weekends and holidays
Let me know if this helps.
Thanks