SUMSQ returns wrong results in a dynamic table

The last row of my table is a total row, in which I’m trying to calculate the sum of squares of the ‘Distance’ column. Since there is no ready-made button for that in the following drop menu

I tried to manually write the following ‘=SUMSQ([Distance])’, as shown in the picture below. 

It appears to work correctly when no filter is active in the ‘complete_linkage’ column. As soon as I apply a filter, SUMSQ behaves very strangely and returns values greater than that when no filter was active.

I honestly have no idea how such values are calculated and how to fix the problem.

Any help is appreciated, thanks in advance.

By: Natashka

Leave a Reply

Your email address will not be published. Required fields are marked *