Knowledge Drop

Why don’t my table calculations have totals?

  • 5 April 2021
  • 0 replies
  • 109 views

Userlevel 4

Last Tested: Feb 14, 2019

As of version 6.2, there are now Totals on Table Calcs in most situations. Note that not all table calcs have totals and also note that some table calc totals may show as incorrect or "unexpected". This goes back to the overarching discussion of Totals are not Totals.

Prior to 6.2, this is expected behavior. The Table Calc columns will not have Totals since table calcs are calculated after the SQL query finishes.

ex.

db197800-2580-4812-af73-860d2e84dbff

A workaround for this case is to create a second table calculation that sums up the original one. This will give you a second column that has the total of the first in every row. For example: sum(${table_calc_1})

 

This content is subject to limited support.                


0 replies

Be the first to reply!

Reply