datediff giving wrong output

Question

I want to calculate difference between project deadline and days completed for all teams and for all stages. I'm getting wrong output, what to do?

I gave DATEDIFF('day',[Enddate],[Startdate]) as the code for calculative field.

Answer 1

Hi,

Try this, AVG(DATEDIFF('day',[Startdate],[Startdate])) .

You are calculating average days of difference.

It will work.