Answers.Body: <p>Workaround -</p>
  
  <p>Select operator as <code>is not one of</code> and multi-select all the values in the dropdown. Result shown will be the record not having the selected values. </p>
  
  <p>For Eg - Financial Type -> is not one of -> all the values in the dropdown -> Preview Report</p>
  
  <p>Can that work for you?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-18T23:15:31.540Z
Answers.Text: That will work most of the time.
Answers.UserDisplayName: Josh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-07T12:45:12.903Z
Answers.LastActivityDate: 2016-03-07T12:45:12.903Z
Answers.UserDisplayName: jitendra - fuzion
Body: <p>I'm currently trying to set up a simple report for bookkeeping transactions for the last month. It's was great except for the fact it is also including paypal fees on top of the full transaction amount (this makes it look very much like we collected the full transaction amount (including the paypal fee), plus we collected the paypal fee as well.) I though it would be simple enough to filter these out, they are easily identifiable by the fact that they don't have a payment method or a financial type at all. I don't seem to be able to filter out null/blank values though: I have to select a value from the list, null/blank is not an option.</p>
  
  <p>I have found I can exclude them based on account codes and this solves my immediate problem. I would, however, like to know if there is a way to exclude items with blank or null values. I could see it being very handy in the future.</p>
  
  <p>It would also be nice to have the pay pal fees subtract their values in a report rather than add them? Possible at all?</p>
  
  <p>Using civiCRM version 4.7.3 right now.</p>
  
Tags: <civireport><reports>
Title: how do I exclude blank or null in a report
ThreadText: # how do I exclude blank or null in a report
  
  (Asked by: username_0 on 2016-03-07)
  
  I'm currently trying to set up a simple report for bookkeeping transactions for the last month. It's was great except for the fact it is also including paypal fees on top of the full transaction amount (this makes it look very much like we collected the full transaction amount (including the paypal fee), plus we collected the paypal fee as well.) I though it would be simple enough to filter these out, they are easily identifiable by the fact that they don't have a payment method or a financial type at all. I don't seem to be able to filter out null/blank values though: I have to select a value from the list, null/blank is not an option.
  
  I have found I can exclude them based on account codes and this solves my immediate problem. I would, however, like to know if there is a way to exclude items with blank or null values. I could see it being very handy in the future.
  
  It would also be nice to have the pay pal fees subtract their values in a report rather than add them? Possible at all?
  
  Using civiCRM version 4.7.3 right now.
  
  **Tags:** civireport, reports
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-03-07. Score: 4 | Accepted answer
  
  Workaround -
  
  Select operator as `is not one of` and multi-select all the values in the dropdown. Result shown will be the record not having the selected values.
  
  For Eg - Financial Type -> is not one of -> all the values in the dropdown -> Preview Report
  
  Can that work for you?
  
  > **Comments:**
  > **username_0**: That will work most of the time.  
  
  ---
  
  