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

Days between Step/Status

48
Views
1
Comments
edited Jul 23, 2016 2:08PM in General Transactional Reporting (OTBI) 1 comment

Summary

OBI Days between Step/Status

Content

I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status. I've tried using the TIMESTAMPDIFF but it doesn't seem to work with CASE WHEN to specify the step and status. Any ideas of what I am doing wrong? Here is an example of the formula

TIMESTAMPDIFF (SQL_TSI_DAY, (CASE WHEN("Submission CSW Status - Historical"."Historical Step Name" = 'Recruiter Review') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'To Be Reviewed') THEN Max("Submission CSW Status - Historical"."Submission Historical Status End Date") END),CASE WHEN("Submission CSW Status - Historical"."Historical Step Name" = 'Recruiter Review') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'Reviewed') THEN Max("Submission CSW Status - Historical"."Submission Historical Status End Date") END)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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