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

pvanerk’s picture

Issue summary: View changes

Typo

karens’s picture

Issue summary: View changes
Status: Active » Closed (won't fix)

The D6 version is no longer supported.