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
22
Views
2
Comments
Molly P
Molly P Rank 4 - Community Specialist
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 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 4 - Community Specialist

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

    Thanks, Molly