Sum the difference between two dates

[#1]

Hi All,

I have a simple sum(if(condition,today() - earlier_date))  and I'm getting an incorrect answer.  The correct answer should be 1083 based on manually looking at the data but the answer I'm getting is 30 680.  Individually, each line is reflecting the correct TAT but the sum of the TATs is wrong. 

Any ideas?

Thanks,

S

[#2]

Hi,

Maybe the some value are duplicate.

Do you can show your example or qvw file?

Thanks