I have a straight table that is displaying total at top. But when I add up the values of the 3 individual rows the total is off by 459,597,417. How can this be?
I assume there's some kind of if() statement or similar in the straight table expression. The total is evaluated on it's own and is not by default the "sum of rows" but is calculated like any other dimension and is almost certainly correct, just not what you expect in this case.
What I think you want to do is change the Total Mode under Chart Properties > Expressions to "Sum of Rows", which will give you the type of total you expect here.
Are you using a Count Distinct? Is it possible that the counted elements appear in several Test Groups?
Take the following scenario: You have ONE customer that buys in TWO Stores. If you set up a straight table to count distinctly the Customers per Store, you will have two rows (1 per Store) and 1 customer on each row, but the total would still be ONE, because it is just ONE Customer.
If you want to make the total the sum of the results of every row (Sum of Rows), specify that in the Expressions tab (in the middle right).
I assume there's some kind of if() statement or similar in the straight table expression. The total is evaluated on it's own and is not by default the "sum of rows" but is calculated like any other dimension and is almost certainly correct, just not what you expect in this case.
What I think you want to do is change the Total Mode under Chart Properties > Expressions to "Sum of Rows", which will give you the type of total you expect here.
