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

CommentFileSizeAuthor
Screen Shot 2013-01-21 at 20.01.42.png302.44 KBspessex
Screen Shot 2013-01-21 at 20.04.32.png148.33 KBspessex
Screen Shot 2013-01-21 at 20.04.46.png138.76 KBspessex

Comments

spessex’s picture

spessex commented

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?

spessex’s picture

spessex commented
Status: Active » Closed (fixed)