Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
6 years ago

Calculating DataDiff in Workingdays with blank values

Goodday brainiacs, i'm in need of your help once again I want to calculate the average time (in workingdays) it takes to fix a complaint or a damage created by our teams   I have a date table with...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi RonaldvdH ,

Is the result like this?

DateDiff = 
IF(
    MAX([Afgehandeld   ]) <> BLANK(),
    DATEDIFF(
        MAX([Binnenkomst]),
        MAX([Afgehandeld   ]),
        DAY
    ),
    DATEDIFF(
        MAX([Binnenkomst]),
        TODAY(),
        DAY
    )
)

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RonaldvdH's avatar
RonaldvdH
Post Patron
6 years ago

v-lionel-msft thanks for the response 🙂 

 

However the result now is that every value is 0,00 and that can't be correct but i feel that is should work.

Both column are in the same table but i need to calculated based on working days so there should be a relation with de DATE table right ?