Grand Totals on a TabPy calc return incorrect values about tabpy

[BBeran]

This is not an issue with TabPy per se. Table calculations in general (which SCRIPT_ calculations are) behave this way. Totals are treated as a separate partition in table calculations.

[cmtoomey]

I think the point of this Issue was that since the data itself doesn't include "Grand Total" as an element, the new element generated by Tableau's calculation/presentation engine shouldn't impact the Python calculation by default. If Grand Totals are being displayed, there should be an Pythonic way to include/exclude their usage through some sort of argument...especially since this "feature" isn't documented anywhere.

[BBeran]

Hi Chris,
I think you misread my comment.

"The new element generated by Tableau's calculation/presentation engine shouldn't impact the Python calculation by default."

This is already the case. Since it is treated as a separate partition, it has no impact how Python computes the rest of the table.

The issue is that grand total itself isn't correct since it is not summing the results of preceding rows in the table. Rather grand total is being treated as a separate, independent table from the rest as is the case with other table calcs.

Thanks,

Bora

[zakahmad]

Correct. The Grand Total doesn't impact how Python computes the rest of the table. But, it does impact the Python calculation as a whole since one Python calc is being used for both the top table and the bottom (grand total) table. The current implementation calls for Python to compute the grand total and it's not possible (see first comment for details on why)

Ultimately, whether this is a TabPy issue or Tableau issue, it's impractical to combine Grand Totals and TabPy calcs.