Manual grade item sum miscalculation

Manual grade item sum miscalculation

by Petr Kalis -
Number of replies: 4
Hi
I am currently battling with strange issue.
I have 9 manual grade item in the category, I want to sum them, but the aggregated values are just not right sad.
See attached image and try to calculate some rows.

The resulting column is just plain sum function (=sum(col1;col2...col9)
Any ideas?
(Happening on 1.9.7)
Attachment grades_miscalculation.png
In reply to Petr Kalis

Re: Manual grade item sum miscalculation

by Elena Ivanova -
Hi Petr,
Can post the screenshot of a formula you are using for the last column?
In reply to Elena Ivanova

Re: Manual grade item sum miscalculation

by Petr Kalis -
Hi
I checked, that all ids are correct and present in the sum function.
Attachment grade_function.png
In reply to Petr Kalis

Re: Manual grade item sum miscalculation

by Petr Kalis -
LOL. It seems, that it depends on the order of the columns in the aggregation function. Columns in function on the picture above were out of order, when I resorted them, the final value looks like fine a correct.
Can anyone try to reproduce it, if it is it?