Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to Suppress Rows with Zero Amounts

Received Response
62
Views
4
Comments
Molly P
Molly P Rank 5 - Community Champion
in Oracle Fusion Data Intelligence

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.

Tagged:

Answers

  • RajeshPolavarapu-Oracle
    RajeshPolavarapu-Oracle Rank 6 - Analytics & AI Lead

    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.

  • Molly P
    Molly P Rank 5 - Community Champion

    This won't work as we need to see negative values as well. The only value we want to exclude is 0.

    Thanks, Molly

  • Vahib Gandhi
    Vahib Gandhi Rank 1 - Community Starter

    We have an exact same requirement and need to figure out a way simple enough for a business user to exclude records with 0 amounts.

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    It's a while I have looked at it, but can you see if it there is an option to create a calculated field. If yes, then create it by checking value is 0 or not. Now you can use this field as a filter. Hope it helps!