Posted by spessex on January 21, 2013 at 8:11pm
1 follower
Jump to:
| Project: | Views |
| Version: | 7.x-3.5 |
| Component: | aggregator data |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Hi
I have a very simple view to test the 'SUM' aggregation type but I cannot get it to work. All I am trying to do is sum the values of two content types decimal fields.
I have one column with content title and one column with value.
Please note I have 'aggregate' on, I have no sort criteria to make things easier, the title column is on aggregation type 'group results together' and the value aggregation type 'SUM' with Group Column 'Value'.
No matter what I do I cannot get the column to sum?
Please note COUNT works.
If anyone could advise it would be most helpful.
Thank you
Stephen
| Attachment | Size | Status | Test result | Operations |
|---|---|---|---|---|
| Screen Shot 2013-01-21 at 20.04.46.png | 138.76 KB | Ignored: Check issue status. | None | None |
| Screen Shot 2013-01-21 at 20.04.32.png | 148.33 KB | Ignored: Check issue status. | None | None |
| Screen Shot 2013-01-21 at 20.01.42.png | 302.44 KB | Ignored: Check issue status. | None | None |
Comments
#1
I have realised that it is paramount that the field that you are grouping by 'makes sense'. For example, it will not work if you group by content title as the content titles (in mine) are distinct. It has to be grouped by something that is valid and that can form a group.
However my issue now is that even though I can get the 'Sum' to work it will not calculate the summation correctly and is way off at the moment?
#2