Answers.Body: <p>Assuming you're using Views - [noticed the tag]! You're definitively on the right track! Drupal Views integration is an extremely powerful way to get more out of your CiviCRM (literally!).</p>
  
  <p>So to handle this add a Filter in Views to not display such NULL results. Here's an example where I want to make sure that addresses without a Latitude or Longitude do NOT get plotted on a Map:</p>
  
  <p><a href="https://i.sstatic.net/xir7s.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/xir7s.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-01T13:55:40.413Z
Answers.LastActivityDate: 2016-06-01T13:55:40.413Z
Answers.UserDisplayName: KarinG - Semper IT
Answers.Body: <p>Since you are Doing Customization, I Suggest that you have a look at the Search Builder because it gives you the possibility define your own search and arrange the criteria according to your own particular needs as opposed to Advanced search which lets you choose from a wide range of criteria in a user friendly manner.</p>
  
  <p>You can read more about Search Builder here <a href="https://book.civicrm.org/user/current/the-user-interface/searching/" rel="nofollow">Searching in CiviCRM</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-02T12:47:57.950Z
Answers.LastActivityDate: 2016-05-02T12:47:57.950Z
Answers.UserDisplayName: Merci Mukwe
Body: <p>I have a number of custom fields. Quite a lot of them are yes select option answers. However a number of contacts have what I think is a null value in them.</p>
  
  <p>So if I search give me everyone who has a yes in the field answer I get the answer 579 for example. If I search is not null I get a much higher value eg 1179.</p>
  
  <p>Does anyone know where his data comes from and what it is? If I get rid of it will it just come back?</p>
  
  <p>The reason I am asking is that I am building a chart in Views where I want to display multiple custom fields in a bar chart. As I am trying to display multiple values I can't filter the data for each custom field rather I am relying on the fact that there is data in the field at all to act as the filter and to ensure an accurate count.</p>
  
  <p>I hope I have explained myself properly! </p>
  
  <p>Thank you!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-02T09:58:14.757Z
Comments.Text: search with not null include both results with No and Yes. Thus the number is higher than just Yes.
Comments.UserDisplayName: Siddharth Gupta
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-02T10:24:02.120Z
Comments.Text: Thanks do you know What is the difference between not null and not empty ?
Comments.UserDisplayName: Caroline B
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-02T15:27:45.400Z
Comments.Text: Null is actually a value, a field that has a null value is not empty. So searching for not empty will result in records that have null too.
Comments.UserDisplayName: Sanjay Jain
Tags: <custom-fields><drupal-views>
Title: Null values -where do they come from
ThreadText: # Null values -where do they come from
  
  (Asked by: username_0 on 2016-05-02)
  
  I have a number of custom fields. Quite a lot of them are yes select option answers. However a number of contacts have what I think is a null value in them.
  
  So if I search give me everyone who has a yes in the field answer I get the answer 579 for example. If I search is not null I get a much higher value eg 1179.
  
  Does anyone know where his data comes from and what it is? If I get rid of it will it just come back?
  
  The reason I am asking is that I am building a chart in Views where I want to display multiple custom fields in a bar chart. As I am trying to display multiple values I can't filter the data for each custom field rather I am relying on the fact that there is data in the field at all to act as the filter and to ensure an accurate count.
  
  I hope I have explained myself properly!
  
  Thank you!
  
  **Tags:** custom-fields, drupal-views
  
  > **Comments:**
  > **username_1**: search with not null include both results with No and Yes. Thus the number is higher than just Yes.  
  > **username_0**: Thanks do you know What is the difference between not null and not empty ?  
  > **username_2**: Null is actually a value, a field that has a null value is not empty. So searching for not empty will result in records that have null too.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_3 on 2016-06-01. Score: 1
  
  Assuming you're using Views - [noticed the tag]! You're definitively on the right track! Drupal Views integration is an extremely powerful way to get more out of your CiviCRM (literally!).
  
  So to handle this add a Filter in Views to not display such NULL results. Here's an example where I want to make sure that addresses without a Latitude or Longitude do NOT get plotted on a Map:
  
  [![enter image description here](https://i.sstatic.net/xir7s.png)](https://i.sstatic.net/xir7s.png)
  
  
  ---
  
  ### Answer by username_4 on 2016-05-02. Score: 0
  
  Since you are Doing Customization, I Suggest that you have a look at the Search Builder because it gives you the possibility define your own search and arrange the criteria according to your own particular needs as opposed to Advanced search which lets you choose from a wide range of criteria in a user friendly manner.
  
  You can read more about Search Builder here [Searching in CiviCRM](https://book.civicrm.org/user/current/the-user-interface/searching/)
  
  
  ---
  
  