7 Replies Latest reply: Mar 12, 2014 6:35 AM by EMMANUELLE DAYOU

# Set analysis problem ?

Hello everyone.

I would like percentages rather than values. So I tried to use the TOTAL with function Count but it does not work.

Does anyone have an idea?

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL {\$<date_entree={"<>0"}>} Matricule)

Emmanuelle

P.S. : My expression is found in the graph at the top right in the INPUT tab-output

• ###### Re: Set analysis problem ?

Emmanuelle

don't understand very well

check if it is what you want

christian

• ###### Re: Set analysis problem ?

I tried this too, but this is not quite right. I would like my total percentage for 2013 is equal to 100%, the same for 2014.

Is that possible to do that ?

Emmanuelle

• ###### Re: Re: Set analysis problem ?

Emmanuelle

here it is

christian

• ###### Re: Set analysis problem ?

Bonjour Emanuelle,

try this expression, the total is bounded to "ANNEE_DATE_ENTREE". Should work as expected.

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL <ANNEE_DATE_ENTREE> {\$<date_entree={"<>0"}>} Matricule)

RR

• ###### Re: Set analysis problem ?

I have a small gap in 2013 but I know how to explain. That's perfect.

Thank you Roland and everybody for your help :-)

• ###### Re: Set analysis problem ?

If you want percentages rather than values, just write a normal simple expression and then check the "Relative" option. If that gives you weird numbers, instead add " & '%' " to the end of your expression.

Cheers,

Lucas

• ###### Re: Set analysis problem ?

See the attached file

try this

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count (TOTAL<ANNEE_DATE_ENTREE> {\$<date_entree={"<>0"}>} Matricule)