Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Isolating a date - Help with a formula
Summary
Isolating a date using by id formula- need guidanceContent
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 )
0