Bad result of an expression in a pivot table

[doespirito]

Hello,

Can someby help me ?

see attached file.

thank you very much.

Arnault

[sunny_talwar · Accepted solution]

Can you use straight table instead of pivot table and use Sum of Rows under 'Total Mode' on the expressions tab?

[sunny_talwar]

Or use this expression in the pivot table:

Sum(Aggr(Round(((Sum({<Entete2={'RESULTAT NET avant fact nr/cp'}>} REEL)+(Sum({<Entete2={'Total des charges yc Exploitation'}>} REEL)*0.01))/Sum({$<RATIO={'EXPOR','EXPORP'}>} REEL_RAT)),0.001)*Sum({$<RATIO={'EXPOR','EXPORP'}>} REEL_RAT), CC_LIB_ND2))

[doespirito]

ok   Sunny,

just using Sum of Rows under 'Total Mode' works

your expression with Aggr works fine too. But is a little more complicated.

thank you very much.

[sunny_talwar]

That is why I suggested using a straight table. Aggr() can be used if you have to use a pivot table for some reason