I'm a Drupal 7 site builder and I need an experienced Drupal 7 module developer to create a patch for the Computed Field module so it works correctly with Views aggregation. This applies to the latest versions of Drupal 7 core, Views 3, and Computed Field.
Only the COUNT function works currently with a computed field but I need the SUM function to work. The computed field is stored in the database as a decimal (10,2) and the Views generated SQL works correctly (copied and tested in phpMyAdmin) but the view only displays one record for each grouped on field. It's like the computed field is being treated as a text field as the configure field settings in the view are not numeric (see attached image).
The problem is easy to reproduce. Create a content type with a computed field and check the boxes for decimal and save to database. Add some content records, create a view and set Use Aggregation to Aggregate, Group By the Title and SUM by the computed field.
I'm using the Views Aggregator Plus module as a workaround but I would prefer to have the aggregation working in Views. I have posted an Issue under the Computed Field module and I happy for the developer to post the patch there and taken the credit for fixing. [login to view URL]