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

Views Calc - with Distinct.png8.82 KBt.lan


jon_stewart’s picture

Subscribing - This occurs for me too.

Skorpjon’s picture


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

Skorpjon’s picture

Status: Active » Closed (duplicate)

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

Skorpjon’s picture

Status: Closed (duplicate) » Active

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

atrofast’s picture

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.

leon85321’s picture

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

Thx for the post.

hobo’s picture

I'm seeing this too.

JCB’s picture

Thanks Skorpjon

Seems like there was a core problem with Node Module.

I applied the patch at comment #127

Here is link to patch:

Solved my problem

truyenle’s picture

same issue and the patch does work for me.

fantasma’s picture

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.

KarenS’s picture

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

The D6 version is no longer supported.

jvieille’s picture

Never fixed, even in D7 apparently.
Using a views with relationships gives my a count either ignoring distinct (counting on a related table field) or 1 (counting on a main table field)