topic Re: Calculated total in group header in Qlik NPrinting

Calculated total in group header

micheledenardi — Tue, 14 Mar 2023 12:17:58 GMT

Dear all,

i have a pixel perfect report structured as below, with some nested levels.

In the lower one i'm trying to create some total in the group header. Number 1, 2, 3 are simply a sum() of the details but the 4th total must be like: total 1 / total 2

I've tried to create a calculated field but it's returning strange values... how to achieve this?

Thanks

Re: Calculated total in group header

Ruggero_Piccoli — Tue, 14 Mar 2023 13:56:30 GMT

Hi,

I did a test on a single level and the total values are correct in both the group header and footer.

Check that you set the correct summary function the Group as summary running.

I did a test with nested levels and also in that case the totals are correct on both the group header and footer.

Be sure you added the group header from the correct level.

Best Regards,

Ruggero

Hi,

Re: Calculated total in group header

micheledenardi — Wed, 15 Mar 2023 07:54:04 GMT

"standartd" sum works as expected.

The problem i have is in a calculated total where i have to pick the first total (sum(qty, which correspond to the total q.ty of the details) and divide with the second total (sum(ship to)).

So i have created a calculated field like below and put into the header but is not returning the correct value...

What am i doing wrong?

i already tried to sum( qty) / sum (ship to) but is not working...

Re: Calculated total in group header

micheledenardi — Wed, 15 Mar 2023 08:21:03 GMT

i found the problem... i was summarize twice... one time in the calculated expression and another time in the group. So i keep only the sum() in the expression and now the result is correct!

Re: Calculated total in group header

Ruggero_Piccoli — Wed, 15 Mar 2023 08:23:57 GMT

I was writing you the same.

Thanks for sharing the solution.

Best Regards,

Ruggero