Set analysis variable

[MauriceLudo]

Hi,

Here is the expression to calculate the percentage

- count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact]) = 270

- $(vMoyenneAnnuelle) = count(DISTINCT {<[Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact])/ Count({<Année = {'$(=Max(Année))'}>} Distinct Mois) = 312

- num(count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact])/ $(vMoyenneAnnuelle),'00,##%') = 2.40%

or

- 270/312=86.53%

I can not identify the error, could you help me please?

Thank you

Maurice

[sunny_talwar]

Which object are we doing this in?

[MauriceLudo]

the first object

Thank you

[sunny_talwar]

I don't see this variable?

vMoyenneAnnuelle

Sorry, but I think your sample seems to be a little different then what you mentioned above. Would you be able to reconcile between the two?

[MauriceLudo]

Sorry i have changed

the new variable vTestT

[sunny_talwar · Accepted solution]

This worked

=(count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [(Ne pas modifier)Prise de contact]))/ ($(vTestT))