14 Replies Latest reply: Jul 18, 2017 7:53 AM by Do espirito Arnault

# straight table : total of expression doesn't work

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

• ###### Re: straight table : total of expression doesn't work

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

but

2721107 / 9640719 .witch is 28,225 %

A.

• ###### Re: straight table : total of expression doesn't work

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

• ###### Re: straight table : total of expression doesn't work

hi andrew,

• ###### Re: straight table : total of expression doesn't work

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

• ###### Re: straight table : total of expression doesn't work

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 :

• ###### Re: straight table : total of expression doesn't work

PFA...

• ###### Re: straight table : total of expression doesn't work

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

but

2721107 / 9640719 .witch is 28,225 %

A.

• ###### Re: straight table : total of expression doesn't work

but the denominator is 9640716 and nor 9640719 Please check

• ###### Re: straight table : total of expression doesn't work

yes 9640716 but it still makes 28.225 %

• ###### Re: straight table : total of expression doesn't work

PFA...

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

Please check highlighted values in excel.

• ###### Re: straight table : total of expression doesn't work

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

• ###### Re: straight table : total of expression doesn't work

try this expression, you will get it what you want

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

• ###### Re: straight table : total of expression doesn't work

thank you it is perfect !

Arnault