Calculated total in group header

[micheledenardi]

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

[Ruggero_Piccoli]

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,

[micheledenardi]

"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...

[micheledenardi · Accepted solution]

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!

[Ruggero_Piccoli]

I was writing you the same.

Thanks for sharing the solution.

Best Regards,

Ruggero