wrong result in pivot table

[doespirito]

Hi,

can anyone explain to me why this simple formula in a pivot table is not correct?

sum(ETC)/count({< VERSION={'REEL'}>} distinct MOIS_PAIE)

Thank you very much

Arnault

[andrey_krylov]

Hi, try to aggrigate your expression

Sum(Aggr(sum(ETC)/count({< VERSION={'REEL'}>} distinct MOIS_PAIE), Yourdimensions))

[manoranjan_d]

try this

sum(ETC)/count(total{< VERSION={'REEL'}>} distinct MOIS_PAIE)

[doespirito]

You put me both on the right track because from 2011 to 2017, I have to divide by 12. It's only in 2018 that we have to divide by the number of months of presence.

I finally put

if (YEAR_PAIE = '2018', sum (ETC) / count ({<VERSION = {'REEL'}>} distinct MOIS_PAIE), sum (ETC) / 12)

Thank you for your help,

Arnault