Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

Categories

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

Missing values/blank cells

Duplicate
13
Views
1
Comments
Andrew at MKL
Andrew at MKL Rank 6 - Analytics & AI Lead
in Oracle Fusion Data Intelligence Idea Lab

Request for a formatting feature to alter how missing data is displayed - would like for '0' to populate instead of blanks (ie. #NumericZero in SmartView). Exported reports with missing values creates blanks and can impact formulas in Excel.

Tagged:
1
1 votes

Duplicate · Last Updated

See Sumanth's comment

Comments

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics & AI Strategist
    edited Sep 7, 2024 10:32AM

    @User_7LKK4 - In Classic analytics there is an option to change blank data to zero(0) values at the column properties level ie. Custom with Custom Numeric Format as ###0;-###0;0

    Currently this feature is not available in Data Visualization.

    An Idea Labs request already exists requesting for this feature to be considered for future releases. Kindly upvote the same with your business needs. Thank you!