Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Isolating a date - Help with a formula — Cloud Customer Connect
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

Isolating a date - Help with a formula

Received Response
37
Views
5
Comments
edited Dec 2, 2016 4:19PM in Reporting and Analytics Taleo Enterprise 5 comments

Summary

Isolating a date using by id formula- need guidance

Content

Hi All,

I have a report with historical step and status changes displaying with dates (multiple rows per application). This is fine.

I have a requirement to add a column to highlight one particular step/status change date and have that date display on all the rows for the application.

I can create a case statement however the date only displays for the row where the step/status change is located (not all the rows)

max(CASE WHEN  "Application Tracking - Historical CSW (No Reverts)"."Application Historical CSW Status ID"=13942 THEN "Application Historical CSW Event Date"."Application Historical CSW Event Date" END )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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