Grand Totals for Table Calc Incorrectly Aggregated when Calculation Based on Same Data Source Field Has "Total Using" Set
Published: 10 May 2017
Last Modified Date: 12 May 2017
IssueWhen a calculated field has a default total using setting, and a table calculation uses the same syntax inside of the table function, then that default total setting is used for the grand total of the table calculation.
[Calc A] is SUM( [Sales] )
[Calc B] is WINDOW_SUM( SUM( [Sales] ))
The default Total Using for [Calc A] is set to average . Then the grand totals for [Calc B] will total using average, regardless of the aggregation chosen for [Sales].
ResolutionAs a workaround, modify the syntax of one of the calculations so they are not identical.
In the above example, we could modify [Calc A] to be SUM( [Sales] ) * 1
CauseThis behavior is related to a known issue with ID 634746 which is currently under investigation.