Oracle Fusion AI Data Platform

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion AI Data Platform

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to exclude a specific value from an expression filter

Accepted answer
50
Views
4
Comments
Kevin Riedy
Kevin Riedy Rank 5 - Community Champion
in Oracle Fusion AI Data Platform

Currently working on a report and coming across an instance in which I do not want NULLS included in my filter.

One Assignment Number can have multiple Last Update Dates. The expression filter that I created (see below) is pulling the last updated LastUpdateDate. Currently, this filter is also removing NULLS from the results. How can I get the filter to exclude NULLS so that NULLS are returned in the report?

I had considered using a Calculation to insert some value into the NULL values, but have not come up with a solution.

My current expression filter: "HCM - Workforce Core"."DFF - Action"."PER_ACT_LASTUPDATEDATE" = (MAX("HCM - Workforce Core"."DFF - Action"."PER_ACT_LASTUPDATEDATE" by "HCM - Workforce Core"."Assignment Information"."Assignment Number"))

Tagged:

Best Answer

  • RVohra
    RVohra Mod
    Answer ✓

    Can you add and see it works

    OR
    (
    "HCM - Workforce Core"."DFF - Action"."PER_ACT_LASTUPDATEDATE" IS NULL
    )

Answers