topic Re: Table sum total incorrect in App Development

Table sum total incorrect

Kaushik2020 — Thu, 03 Aug 2023 08:57:55 GMT

Hi all, I am using QS Server version - 14.78.0

the sum of table count is not correct.

Aurelien_Martinez — Thu, 03 Aug 2023 09:12:02 GMT

Hi,

Can you share your expression?

I can try to change the total function in your measure.

Kaushik2020 — Thu, 03 Aug 2023 09:32:17 GMT

thanks for the information. it was set to default. I changed to Sum as per your suggestion and it's working fine now.

Do you know why with Auto - it was calculating incorrectly Or what happens in the background.

coz other columns were calculating correctly.

Aurelien_Martinez — Thu, 03 Aug 2023 09:40:45 GMT

It's depending of your expression. For example if you have a Count(distinct ID) :

The expression is evaluate on each row, with my data :

Level 1 : ID=1, ID=2 => 2

Level 2: ID=1 => 1

Total : ID=1, ID=2 >=2

Kaushik2020 — Thu, 03 Aug 2023 13:21:21 GMT

thanks a lot for the explanation 🙂