For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need 2 Date Fields having Case or Filter functionality in OTBI Report
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.