Hi,

I had duplicate entries in my view so I activated the Distinct option. But Views Calc now still sums up also the omitted rows. This results in a sum that has exactly the duplicate total of the the above numbes in the visible rows.

Am I doing something wrong?

Regards, Thomas

Files: 
CommentFileSizeAuthor
Views Calc - with Distinct.png8.82 KBt.lan

Comments

Subscribing - This occurs for me too.

Subcribing

Same bug. For the user 1 it shows the right value. Everyone else gets the double value.

Status:Active» Closed (duplicate)

It is not a problem of Views Calc. Duplicate of http://drupal.org/node/284392

Status:Closed (duplicate)» Active

My mistake. But take a look at http://drupal.org/node/681760. This could fix the problem...

I have the same problem, there are duplicates in the SUM but not the results after turning distinct on. I haven't tried applying any of those patches to core, and frankly am a little worried about doing so until there is a proper release. Can anyone confirm those changes fix this problem? Thanks.

#4 fixed that problem!
Only comment out 3 lines, and add 4 lines of code will do it!

Thx for the post.

I'm seeing this too.

Thanks Skorpjon

Seems like there was a core problem with Node Module.

I applied the patch at comment #127
(http://drupal.org/node/681760#comment-4371188)

Here is link to patch:
http://drupal.org/files/issues/681760_node_access-127-D6.patch

Solved my problem

same issue and the patch does work for me.

Today i discovered this problem as well. The problem appears if a node access module (using grants) is used.
If only one grant is active, everything works fine. Two active grants will double the result, and so on.
The problem disappears if "hook_node_grants($account, $op)" in the node access modul only returns one grant id for a realm.
I can live with this solution, bit this should be fixed in Views Calc.

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

The D6 version is no longer supported.