Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 254 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 94 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"))
Best Answer
-
Can you add and see it works
OR
(
"HCM - Workforce Core"."DFF - Action"."PER_ACT_LASTUPDATEDATE" IS NULL
)0
Answers
-
@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
1 -
Hi @RVohra this did work for us, thank you!
1 -
Thanks for updating the post, appreciate it.
0