make a sum of table columns

[#1]

hi, i make a sum of a table columns and this expression don't give me a good result

[spividori]

Hi.
I had the same problem and solved it by performing the calculations in the script.

If you do not understand up a excel values to give you an example.

Regards.

Sandro.

[#3]

Hi

Try with a straight table instead of pivot.

Then choose Sum of rows as Total Mode.

Bonne année

JJ

[#4]

thx Mister

but i have another problem i have in my file a periode and i would like to build a table where there are some account compt group by period

exple

compte Period 1 Period 2

100011 100 000 200 000

in the table Period 0 1 2 3 4 5 6 7 8 9 10 11 12

Period1 = Period<=1

the expression that i writre

Sum({$<PERCP={"<=1"}>}((SoDebit+MvtDebit)-(SoCredit+MvtCredit)))

and this expression returns 0