Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Could every-body help me to know (see attached file) whitch mistake i make in this straight table.
One élément of a dimension desappears in the average amount.
thank you very much.
Best regards,
Arnault
May be this:
round((Sum({$<MOIS={"<=$(=max(MOIS))"},[CANALCOM]={'OUI'}>} (VENTEOJD)) / max(TOTAL MOIS)))
PFA
Just use the expression total instead of sum of rows.
ok thank you,
but one element (37261 whitch is 192 in november) , has desappeared in the straight table.
do you know why ?
May be this:
round((Sum({$<MOIS={"<=$(=max(MOIS))"},[CANALCOM]={'OUI'}>} (VENTEOJD)) / max(TOTAL MOIS)))
yes it is perfect.
just a question : why do i have to add TOTAL here ?
thank you very much
your expression max(MOIS) returns null for the ID 37261 since it has value in the mois of 11 therefore the 37261 returns'-' and automatically suppressed
you need to to use max(total MOIS) to return 12 or if you want to return 11 which is max(mois) for value 37261 use this exp Max({$<MOIS={"<=$(=max(MOIS))"},[CANALCOM]={'OUI'}>}MOIS)
since you need avg for 12 months max(total MOIS) will be your expression
Hope it helps
Max(MOIS) for 37261 was somehow showing as null... changed it to Max(TOTAL MOIS) which calculate Max MOIS across all the INSEE
Aar, Sunny,
Your answers are very clear.
Thank you very much.
Arnault