Customized Reports: Filters add "isBlank" testing for blank field
I create a report that looks for blank fields, eg-- someone needs to enter data or get a task completed.
I have not found a way to create a report and filter for a blank or non-blank field. If added a value of "IsBlank" that would be helpful.
Field:CloseDate equals isBlank (Returns all records that do not have a close date)
Field:CloseDate not equal to isBlank (Returns all records that have a close date)
(Field:DateQuoted not equal to isBlank ) and (Field:PORecievedDate equals isBlank) (Returns all records where a quote has been issued but no order recieved)
- 5 years ago
Ever wish you could run reports on the fields you have in salesforce? Take a Field Trip! This utility lets you analyze the fields of any object, including what percentage of the records (or a subset of your records) have that field populated.
One Market St.
San Francisco, CA 94105
If you still can't find what you're looking for, try to submit a case.
Powered by Community Cloud platform. Learn More ›
Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.
Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.
Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.
Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.