Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, try to aggrigate your expression
Sum(Aggr(sum(ETC)/count({< VERSION={'REEL'}>} distinct MOIS_PAIE), Yourdimensions))
try this
sum(ETC)/count(total{< VERSION={'REEL'}>} distinct MOIS_PAIE)
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