Sum for some columns does not work

I have exactly the same problem - a simple sum only grabs the top row of the view ignoring all other rows.
The originating values come from a Webform where the fields are of type Number. I have even tried rewriting the field in Views then setting the formatter as string, plain text.

Regards,

Kerry Gray

Hi Narongwit & Kerry,
Thank you for your reports but your descriptions currently do not have enough detail for me to reproduce the problem.
More detail means greater chance of a solution.
Rik

I will say that I just found this thread and was writing a very long and detailed post...and then I went and turned off Aggregation on the actual view and made sure I was using the views aggregation table and that seemed to clear the no sum error for me..I guess that maybe both were canceling each other out.

@100ph0le:

Thanks for your comment. You may have solved Narongwit's and Kerry's problems as well. I am sorry it took you a while to figure it out. However I plead innocent ;-) referring to the README :

HOW TO USE
----------
......

Views Aggregator Plus does not combine well with Views' native aggregation.
So in the Advanced section (upper right) set "Use aggregation: No".

Hopefully, your journey with this module has no further humps.

Rik

Is it related to this other issue.

@mgifford:

Could well be. Thanks!

That issue is now fixed. Based on that and l00ph0le's comment above I'm going to consider this one fixed.

Please re-open anyone, if you still have issues. But please state clearly the circumstances to reproduce the problem. Like what kind of View (Webform, Commerce etc.) and what kind of data (money, text, float), etc...

Rik

I have to open this as I'm having this same error: sum only sums first row of a normal field collection item's view (no webform or commerce). I'm not using view's aggregation, only views aggregator plus. The fields to sum are computed fields. Table has no order. Even, when I apply and change the order, sum only give me the value of the first computed field.

@robergarrigos
I'm not surprised it doesn't work for Field Collections. I've never tested it with that.
Rik

ok thanks @RdBoer then I close this issue and open a new one for field collections only for reference (https://www.drupal.org/node/2791169)

I'm having the same issue. I can sum other columns, but when the column is displaying the results of a computed field, the sum result always shows only the first item in the column as the result, ignoring the other rows and as a result no summing. Changing the formatting of the field to plain text has no effect.

@robertgarrigos, did you find a solution/workaround to this?

sorry @hondaman900, I haven't.

hi @hondaman900

I think you have to also apply/enable a sum function to your computed field..

BE CAREFUL concerning the sum function TO ENABLE on computed field

sum function to enable in table aggregate settings is the one in Group aggregation AND NOT the one in Column aggregation