The Views Calc doesn't return the right sum when using Organic Groups.
Example:
A node has a relation with two organic groups A and B.
User 1 has access to group A.
User 2 has access to group A and B.
We have defined a view which shows the node correct. Attached is a views calc sum.
When user 1 opens the view (with the views calc as a block):
The view displays the node once
The views calc displays the right sum (the value of the node)
When user 2 opens the view:
The view displays the node once
The views calc displays the sum as twice the value of the node.
When I use more Organic Groups, then the sum value increases with the amount of Organic Groups.
The query which is returned by the views module looks correct. I guess afterwards some modification is done to the query to take care of the security.
When I disable SQL rewriting, the views calc returns the right sum (but you don't want this because the security regarding Organic Groups is skipped).
I guess there is a relation with the following issue #1163078: Views Calc not summing values correctly
Comments
Comment #0.0
pvanerk commentedTypo
Comment #1
karens commentedThe D6 version is no longer supported.