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

[techvarun]

[doespirito]

thank you but i don't want the average of lines witch is 28,146%

but

2721107 / 9640719 .witch is 28,225 %

A.

[effinty2112]

Hi,

You'd be as well to replace Column(5)/Column(3) with the actual expressions and the summary should work. This column(number) business is all very well but if new columns are inserted or columns moved it can all turn sour.

cheers

Andrew

[prma7799]

PFA...

[doespirito]

hi andrew,

it's what i made first, but no results for total expression too.

[doespirito]

sorry but  i don't want the average of lines witch is 28,146%

but

2721107 / 9640719 .witch is 28,225 %

A.

[techvarun]

but the denominator is 9640716 and nor 9640719 Please check

[effinty2112]

Hi

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

doesn't look quite right.

Maybe:

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

or

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

Good Luck

Andrew

[doespirito]

yes 9640716 but it still makes 28.225 %