Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I created a Salesforce report and want a field to be filtered to only show the ones containing certain text.
I used a filter with contains: MXN APT SET
It shows those (about 800 results) but also the ones that are with "-" (Over 900k results!)
And I can't find a way to filter the outcome without those "-"
I had tried adding another filter using.
But still not working. Any Idea how I can get rid of those blanks?
The Notes about Filtering on Types of Fields and Values should help you here. Basically, when you configure the filters for your report choose the field and the “not equal to” operators, leaving the third field blank. There's also a video from Salesforce Support on filtering our these blank values across a range of different places here.
