Running Time Using If Statement
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?