Running Time Using If Statement

Content

Hi All,

Can someone help he how can I get the Running Total of Days Open and Turn Around Time for my report. This two should be in one column and i think i need to use If Statement. What i have right now is:

if(incidents.closed>0, date_diff(incidents.closed, incidents.created), date_diff(incidents.created, sysdate())

But it doesn't work. There are some error with my formula.

Can someone help me to find this out?

Thanks!

JOvit