CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Fields that are blank are showing as "0" on report

edited May 11, 2018 5:37AM in CRM On Demand - Reports and Dashboards (MOSC) 6 commentsAnswered ✓
I have created a report where I need to count specific fields that have been filled in on our Account records.  We have a field where the type is set up as a Percent so the sales rep just enters a number and it shows it as a %age.  The issue I am running into is when I place this field on a report, it displays a blank value as 0%, so my count function is counting it as an entry.  My solution was to turn this field to NULL if it was =0, which seemed to work fine.  Then I found

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center