straight table : total of expression doesn't work

[doespirito]

hi every body,

I can't understand why total of expression doesn't work in this straight table :

i should have 28,22 % witch is : 2721107 / 9640719 .

see attached file,

thank you very much for your help

Arnault

[prma7799]

PFA...

I think because of that pointer values the rest of total is showing  28.145654092904%.

Please check highlighted values in excel.

[doespirito]

highlighted values are correct in excel and final total must be 28,22%

[doespirito]

you are right, i had a mistake, the rigt formula is

(sum(surface)*sum(tirage2))/(sum(pag2)*sum(tirage2))

but

result is still wrong :

i want 28,22 %

in excel :

[Kushal_Chawda · Accepted solution]

try this expression, you will get it what you want

sum(aggr((sum(surface)*sum(tirage2)),editionsec))/sum(aggr((sum(pag2)*sum(tirage2)),editionsec))

[doespirito]

thank you it is perfect !

Arnault