Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 21 Oracle Analytics Lounge
- 251 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 93 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to exclude a specific value from an expression filter
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"))
Answers
-
Can you add and see it works
OR
(
"HCM - Workforce Core"."DFF - Action"."PER_ACT_LASTUPDATEDATE" IS NULL
)0 -
@Kevin Riedy , Hope you are doing well and your issue is resolved. If above answer worked for you, please mark it as Accepted Answer. You can read about the community guidelines/KB - Oracle Analytics Knowledge Base - Oracle. Thanks
0
