Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to Suppress Rows with Zero Amounts

Molly P
Rank 5 - Community Champion
How do we suppress rows with zero amounts on fields of measure? I can't filter out zeroes because the filter type is "range." I tried using a CaseIf function and the <> operator with no success. Please advise if this is possible.
0
Answers
-
Hi @Molly P
If the filter type is range then give the range between 1 to <some big number> .
So, that the rows with value 0 will get excluded.0 -
This won't work as we need to see negative values as well. The only value we want to exclude is 0.
Thanks, Molly0