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.