What's new in Customer Journeys?

Connect and learn more! ×
Need 2 Date Fields having Case or Filter functionality in OTBI Report — 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

Need 2 Date Fields having Case or Filter functionality in OTBI Report

Accepted answer
47
Views
9
Comments

Summary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%')

and Final Review Date ("Performance Document"."Performance Document Period Name" like '%Final%') based on Document Name.

Content (please ensure you mask any confidential information):

When Date is displayed in Interim Review Date, Final Review Date should show 'N/A' just like other columns.

If Interim Review Date: 04/30/2025 then Final Review Date: 'N/A' and vice versa.

However, right now, Date is displayed under both the fields irrespective of the Condition and the Filter applied, with more than 1 value.

I guess I'm not getting the correct syntax. Please help in correcting these 2 columns.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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