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

Suppress zeroes and nulls in FDI Data Visualization

Received Response
41
Views
3
Comments
Andrew at MKL
Andrew at MKL Rank 5 - Community Champion
in Oracle Fusion Data Intelligence

I am hoping to suppress all of the rows showing with null or zero in the screenshot below, while retaining all rows that show values other than zero. I've seen some options for an Expression Filter using the 'Aggregate By' function, but have not yet been successful. I'd also like to convert the nulls to zeroes if at all possible. Any help is most appreciated, thanks!

image.png
Tagged:

Answers

  • Phani Srikantam
    Phani Srikantam Rank 2 - Community Beginner

    Hi Andrew,

    Can you give more details on the use case so that we can help.

  • Andrew at MKL
    Andrew at MKL Rank 5 - Community Champion

    Hi PhaniPhani,

    Can you describe what additional details would be helpful? I'm hoping to suppress rows where only zeroes or nulls exist, and to convert all nulls/blanks to zeroes.

  • Sindhusha Kukkadapu
    Sindhusha Kukkadapu Rank 3 - Community Apprentice

    I’m encountering the same issue in the report. I want the data for one ledger to appear in a single row, but currently, it's showing up in three separate rows. Please help me resolve this."

    Screenshot 2025-05-22 125626.png