Skip to main content
Topics#Reports & DashboardsMelanie Anguay 的问题
Melanie Anguay (If/When/How) 提问于 #Reports & Dashboards
2019年9月30日 18:46

How to filter data in a custom field

Hi! I have a custom field in my Contact object. The field's name is Law School. Contacts can list which law schools they attended. Our Contacts have attended a variety of law schools. How do I create a filter in a report that shows all Contacts who have data in this field? 
1 个回答
  1. Anthony McDougald (N/A)
    2019年9月30日 19:03
    Hello Trailblazer,

     

    Hope that your day is off to an amazing start! You want to click the Filters tab on your lightning report, click in the search bar and find your custom field (Law School), set the operator to not equal to, and leave the value text box under the operator blank (nothing in it). This will give you all the Contact records that have some value in the said field and exclude all records that doesn't have data in the said field. Example picture is below with a different field for a reference. Thank you and have a blessed day.

     

    Hello Trailblazer, Hope that your day is off to an amazing start! You want to click the Filters tab on your lightning report, click in the search bar and find your custom field (Law School), set the o

     

    Best Regards,

     

    Anthony McDougald
撰写回答...
0/9000