Body: <p>The Summary Fields extension is storing results as Money fields which are text format.  This prevents them from being used to filter as numerics in Views and other places.</p>
  
  <p>Is there a way to have the fields created as number fields?</p>
  
  <p>Upon further examination, the field appears to be correct in the MySQL database yet both Drupal Views and Search Builder do not handle the fields correctly.  Views filters think it is a text field.  Search builder queries show incorrect boolean behaviors.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-20T00:41:06.790Z
Comments.Text: Have you had any luck with this? I am having the same problem?
Comments.UserDisplayName: Steve Kessler
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-04T03:24:17.760Z
Comments.Text: No, but still interested.  Maybe its a bounty opportunity
Comments.UserDisplayName: Dave T
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-19T00:55:58.243Z
Comments.Text: This isn't a good answer so i'll post it as a comment in case anyone needs this quickly... If the ultimate goal is to filter in views as a number field.. text filter handler is default so somewhere it needs to be overridden. Can be done quickly in a module as per the third code example here: https://api.drupal.org/api/views/views.api.php/function/hook_views_data_alter/7.x-3.x. May also need to put your module at the end of the list to act after civicrm (https://api.drupal.org/api/drupal/modules%21system%21system.api.php/function/hook_module_implements_alter/7.x)
Comments.UserDisplayName: Eli Lisseck
Tags: <summaryfields>
Title: Is there a way to use number format for Summary Fields extension
ThreadText: # Is there a way to use number format for Summary Fields extension
  
  (Asked by: username_0 on 2015-11-28)
  
  The Summary Fields extension is storing results as Money fields which are text format. This prevents them from being used to filter as numerics in Views and other places.
  
  Is there a way to have the fields created as number fields?
  
  Upon further examination, the field appears to be correct in the MySQL database yet both Drupal Views and Search Builder do not handle the fields correctly. Views filters think it is a text field. Search builder queries show incorrect boolean behaviors.
  
  **Tags:** summaryfields
  
  > **Comments:**
  > **username_1**: Have you had any luck with this? I am having the same problem?  
  > **username_0**: No, but still interested.  Maybe its a bounty opportunity  
  > **username_2**: This isn't a good answer so i'll post it as a comment in case anyone needs this quickly... If the ultimate goal is to filter in views as a number field.. text filter handler is default so somewhere it needs to be overridden. Can be done quickly in a module as per the third code example here: https://api.drupal.org/api/views/views.api.php/function/hook_views_data_alter/7.x-3.x. May also need to put your module at the end of the list to act after civicrm (https://api.drupal.org/api/drupal/modules%21system%21system.api.php/function/hook_module_implements_alter/7.x)  
  
  ---
  
  ## 0 answers
  
  