You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Running Time Using If Statement

Accepted answer
3
Views
1
Comments
edited Jul 26, 2018 9:24PM in Reporting & Analytics for B2C Service 1 comment

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

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!