Fields that are blank are showing as "0" on report
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
0